• 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
Marshal
Posts: 35279
384
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic