> What then is the Heuristic of spacing COMMITS ?
>
> -----Original Message-----
> From: Jared Still [SMTP:jkstill_at_bcbso.com]
> Sent: Tuesday, May 23, 2000 11:28 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: To Commit or NOT to Commit
>
>
> Committing every thousand rows is much to often on millions
> of rows.
>
> This will cause a commit every few seconds, or maybe every
> couple of seconds on a fast system, with all of the inherent
> overhead.
>
> Jared
>
>
> -----Original Message-----
> From: Steve Adams [SMTP:steve.adams_at_ixora.com.au]
> Sent: Tuesday, May 23, 2000 4:28 AM
>
> Hi All,
>
> Every commit waits for a log write and 3 scheduling latencies.
> There may be good reasons for coding procedures to commit intermittently,
> but you should keep those commits as infrequent as possible.
>
> Regards,
Received on Wed May 24 2000 - 03:30:02 CDT
