File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes Performance Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Performance" Watch "Performance" New topic


avihai marchiano
Ranch Hand

Joined: Jan 10, 2007
Posts: 342

I know that the answer to performance question is always - "depend".
Depend on the hardware , depend on the DB and etc.

But still i am going to ask, and i need only "feeling" no something accurate.

How much jdbc batch insert i can do for a sec based on average server?

Thank you
Jimmy Clark
Ranch Hand

Joined: Apr 16, 2008
Posts: 2187

This will depend upon things such as number of tables involved in INSERT statements, number of columns invloved, datatypes of columns, byte size of data values, for example.

Also, it depends upon how the JDBC-based statements are actually executed, e.g. via CMP EJB, Hibernate, hand-coded JDBC, in application server, standalone JRE, etc.

Hope this helps!
I agree. Here's the link:
subject: Performance
Similar Threads
help me please to choose the best
Log4j ConsoleAppender Vs System.out.println() Performance
Same controller for application client and Browser
performance question: count(*) vs count(<columnName>)
Do filters affect web application performance?