Subject | Commit vs Commitretaining |
---|---|
Author | Roger Pullen |
Post date | 2002-01-19T10:31:03Z |
Hi
Is there a performance difference between commit
and commitretaining on a transaction
We seem to find lengthy delays operating over a phone
line making sure everything is committed before
running a new query. We think it may be due to
exessive commits rather than commitretainings.
Does the transaction isolation level make a difference as well?
Any thoughts
Regards
Roger
Is there a performance difference between commit
and commitretaining on a transaction
We seem to find lengthy delays operating over a phone
line making sure everything is committed before
running a new query. We think it may be due to
exessive commits rather than commitretainings.
Does the transaction isolation level make a difference as well?
Any thoughts
Regards
Roger