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]

Reply via email to