I agree with u completely......... the frequency does matter and we need to
think a little before deciding on that.
----- Original Message -----
From: guy ruth hammond <grh_at_agency.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Tuesday, May 23, 2000 2:23 PM
Subject: 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 Mercy
>
>
> --
> Author: guy ruth hammond
> INET: grh_at_agency.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue May 23 2000 - 04:24:37 CDT
