| Performance of application [message #181218] |
Fri, 07 July 2006 08:48  |
agowda
Messages: 1
Registered: July 2006
|
Junior Member |
|
|
Hello:
I have an application which updates the remote database throguh DB link. I have 10 updates and insert queries. I am committing only after all the 10 queries are executed. Is this good or should I commit after each statement. I use Javv code for executing the queries
Thanks for any help!
|
|
|
|
| Re: Performance of application [message #181247 is a reply to message #181218] |
Fri, 07 July 2006 11:19  |
Art Metzer
Messages: 2480
Registered: December 2002
|
Senior Member |
|
|
Well, this question can really be answered only by you.
Do the ten updates as a unit constitute a single logical transaction?
Or is each individual update a logical transaction in its own right?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
