What is the problem with your current performance? -----Original Message----- From: Shailender Jain [mailto:[EMAIL PROTECTED] Sent: Monday, July 26, 2004 6:37 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] “This e-mail is sent on the Terms and Conditions that can be accessed by Clicking on this link http://www.vodacom.net/legal/email.asp " --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]