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

Win a copy of Make it so: Java DB Connections & Transactions this week in the JDBC forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Performance for batch update" Watch "Performance for batch update" New topic

Performance for batch update

Martin Lira
Ranch Hand

Joined: May 26, 2004
Posts: 97
I have a stored procedure that will be called in a loop and might be executed several times. Will the use of executeBatch affect the performance as its a stored procedure and not a direct sql insert.

Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 32844

The batch still saves on network roundtrips. So if you can use batches, you would still be better off to do so.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: Performance for batch update
It's not a secret anymore!