For this procedure would be the best bet...Reason := Oracle will take care of the entire operation, Instead of mutilpe database hits from the application its better to transfer the control and process....no need of breaking it into batches also then...
Regards Amit -----Original Message----- From: Shailender Jain [mailto:[EMAIL PROTECTED] Sent: Monday, July 26, 2004 6:48 PM To: Struts Users Mailing List Subject: Re: executeBatch for (CONDITION) {insert into } Amit Kumar Sharma wrote: > Dear Shailender, > > What type of insert are you trying to do, is it a single insert(eg: > Insert into (select * from *)) or multiple insert (eg > for(CONDITION){insert into}) > > Regards > Amit > > -----Original Message----- > From: Shailender Jain [mailto:[EMAIL PROTECTED] > Sent: Monday, July 26, 2004 10:07 AM > To: [EMAIL PROTECTED] > Subject: executeBatch > > Hi, > > I want to insert some 3000 records in the database. > > I tried using executeBatch() to insert all the records at a go. > But the application gets hang and nothing happens. > > When i try using PreparedStatement then it does work and just takes some > 30 seconds. > I am using Informix as the database and the DriverClass in ifxjdbc.jar. > I checked the specification of the driver > and it promises to be jdbc2.0 compliant. > > Any idea on how to improve the performance? > > Regards > Shailender Jain > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
