Hi, I experimented this executeBatch with 13500 records.
Here are the results Number of Records At one Time Time 100 20 Seconds 200 45 Seconds 500 Application Hang The only Quesion here is why there is a optimium result for 100 records? Regards Shailender Jain [EMAIL PROTECTED] wrote: > Did you experiment breaking the batch to 2-3 packs? (500-800 in one go). > > - regards > > Raj > (+91-11-31261821) > > -----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] > > Confidentiality Notice > > The information contained in this electronic message and any attachments to this > message are intended > for the exclusive use of the addressee(s) and may contain confidential or privileged > information. If > you are not the intended recipient, please notify the sender at Wipro or [EMAIL > PROTECTED] immediately > and destroy all copies of this message and any attachments. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED]
