aspose file tools*
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
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Performance" Watch "Performance" New topic
Author

Performance

avihai marchiano
Ranch Hand

Joined: Jan 10, 2007
Posts: 342
Hey,

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
Depends...

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: http://aspose.com/file-tools
 
subject: Performance