Re: commit

Just to add to what everyone's said: I do a LOT of batch operations, and through testing I have found out that if you commit after every insert/update vs after every 100 or more, you are running about 20%-50% slower. It seems to be an inverse relation (ie: follows the same pattern as y = 1/x), meaning that the difference in going from committing every 1 to every 100 records is many times greater than the difference in going from committing every 500 to every 600 records.

I imagine your results will vary based on many things, but the pattern seems to lead to the same conclusion: Commiting after every DML operation is the absolute worst thing you could do in terms of Oracle performance. Received on Tue May 15 2001 - 18:22:10 CDT