File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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
 
Consider Paul's rocket mass heater.
 
subject: jConnect and Performance : !!!HELP!!!
 
Similar Threads
How to handle RAISEERROR in Sybase using JDBC
Slackware
Connection Pooling using JNDI
Unable to Iterate over large number of records
maximum length of identitifer in Sybase for insert query