| Author |
Performance for batch update
|
Martin Lira
Ranch Hand
Joined: May 26, 2004
Posts: 97
|
|
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
internet detective
Marshal
Joined: May 26, 2003
Posts: 26496
|
|
Martin,
The batch still saves on network roundtrips. So if you can use batches, you would still be better off to do so.
|
[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
|
|
 |
|
|
subject: Performance for batch update
|
|
|
0
