Re: Deadly sins againts database performance/scalability

Mark D Powell wrote:
>
> You can disagree, but I think your are failing to consider how much
> real world work is done in batch type processing.
>
> -- Mark D Powell --

And I will. I remember the first time I was a Boeing and wrote code that did that. Seemed reasonable at the time as I was bringing in gigabytes every weekend. But now with UNDO I'd argue just the opposite. Disk is so inexpensive it makes no sense not to just assign the equivalent of 1 or more drives, often 40+GB to UNDO and let it run to comletion.

But your point is valid in a datawarehouse situation. Can we at least agree that commits in OLTP loops is almost undoubtedly without merit.

-- 
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)