• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Performance

 
avihai marchiano
Ranch Hand
Posts: 342
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2187
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic