This week's book giveaway is in the Design forum.
We're giving away four copies of Building Microservices and have Sam Newman on-line!
See this thread for details.
The moose likes JDBC and Relational Databases 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 Building Microservices this week in the Design forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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!
Have you checked out Aspose?
subject: Performance
It's not a secret anymore!