wood burning stoves 2.0*
The moose likes JDBC and the fly likes jConnect and Performance : !!!HELP!!! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "jConnect and Performance : !!!HELP!!!" Watch "jConnect and Performance : !!!HELP!!!" New topic
Author

jConnect and Performance : !!!HELP!!!

Praveen Kumar Jha
Greenhorn

Joined: Jul 27, 2002
Posts: 10
Hello,
I am using Sybase jConnect for writing large amounbt of feed to database. I am using prepared statement and batch commit - but performace still seems to be poor. There are some 100 fields per row and it is taking 60 seconds to insert 1000 rows.
Any clue to improve the performace.
thanks,
Praveen


Praveen Kumar<br />Sun Certified Programmer for Java 2 Platform
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: jConnect and Performance : !!!HELP!!!
 
Similar Threads
How to handle RAISEERROR in Sybase using JDBC
maximum length of identitifer in Sybase for insert query
Slackware
Connection Pooling using JNDI
Unable to Iterate over large number of records