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
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: jConnect and Performance : !!!HELP!!!