This week's book giveaway is in the General Computing forum.
We're giving away four copies of Arduino in Action and have Martin Evans, Joshua Noble, and Jordan Hochenbaum on-line!
See this thread for details.

The moose likes JDBC and the fly likes jConnect and Performance : !!!HELP!!!

A friendly place for programming greenhorns!

Big Moose Saloon

Search | Java FAQ | Recent Topics

Win a copy of Arduino in Action this week in the General Computing forum!

A special promo: Enter your blog post or vote on a blogger to be featured in an upcoming Journal

JavaRanch » Java Forums » Databases » JDBC

Author

jConnect and Performance : !!!HELP!!!

Praveen Kumar Jha
Greenhorn

Joined: Jul 27, 2002
Posts: 10

posted

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://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.

subject: jConnect and Performance : !!!HELP!!!

Similar Threads
maximum length of identitifer in Sybase for insert query
Slackware
Connection Pooling using JNDI
How to handle RAISEERROR in Sybase using JDBC
Unable to Iterate over large number of records