Committing 100 records vs 100,000 records, which one is faster?
ZAMay 13 2008 — edited May 14 2008Hi,
I have a question related to committing a transaction. If I have two different sessions in which user A inserts 100 records and commits, and user B inserts 100,000 records (may be more) and commits, which commit is faster?
And in the same scenario, if both of them rollback, which rollback would be faster?
As per my understanding, inserts/updates/deletes will go in dirty buffers of respective users and once commit is issued, system will do the disk I/O, so more data would mean more time. Similar would be the case for rollback.
Can someone throw some light on it please!
Best Regards,
Zaaf