Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: To Commit or NOT to Commit
Atish Prasad Das wrote:
>
> frequent commits are always good...
Yes and no. I remember one developer who was importing million-line text files, and committing after each row. And I remember the look of shock on his face when I modified his program to commit every 500 rows and improved its performance by an order of magnitude... and we could probably have achieved even greater performance by proper tuning and optimization. :0)
g
-- guy ruth hammond <grh_at_agency.com> | Happiness is a loaded weapon, and Technology Analysis & Consulting | a short cut is better by far. 07879607148 http://www.agency.com | -- The Sisters of MercyReceived on Mon May 22 2000 - 16:02:21 CDT
![]() |
![]() |