Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: To Commit or NOT to Commit

Re: To Commit or NOT to Commit

From: guy ruth hammond <grh_at_agency.com>
Date: Mon, 22 May 2000 22:02:21 +0100
Message-Id: <10506.106327@fatcity.com>


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 Mercy
Received on Mon May 22 2000 - 16:02:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US