This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
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 OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA 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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: jConnect and Performance : !!!HELP!!!