Re: Deadly sins againts database performance/scalability

Mark D Powell wrote:

<snipped>
>
> Dusan, I would suggest you change your wording about issuing commit
> within a loop since in many cases the commits need to be performed
> within a loop. I think it is the frequency of commits rather than the
> logical coding structure that is the issue.
><snipped>

Going to take issue with you here Mark. Granted that nothing should ever been done dogmatically. But 98% of the time a commit in a loop is not needed, not desirable, the result of someone moving from another RDBMS or someone that has poorly configured rollback.

The rare times that a commit in a loop is required are the extreme exception.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)