• Post Reply Bookmark Topic Watch Topic
  • New Topic

Performance for batch update

 
Martin Lira
Ranch Hand
Posts: 97
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
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.

-Martin
 
Jeanne Boyarsky
author & internet detective
Sheriff
Posts: 35977
422
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Martin,
The batch still saves on network roundtrips. So if you can use batches, you would still be better off to do so.
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!