wood burning stoves 2.0*
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 Murach's Java Servlets and JSP this week in the Servlets 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!
wood burning stoves
subject: Performance
Similar Threads
Same controller for application client and Browser
Do filters affect web application performance?
performance question: count(*) vs count(<columnName>)
help me please to choose the best
Log4j ConsoleAppender Vs System.out.println() Performance