Complete agreement, but I do have a special case answer to your wonder. Actually, a special class. Every useful system I'm aware of that stores information that is rarely read is functionally like the black boxes in airplanes. You never want to read it, but you've got to have it, and once in a while you have to read it. There is another class that is about 1:1, that being operational data stores where you capture, cleanse, aggregate and pass on to datamarts, warehouses, or whatever other buzzword has been recently generated. But that doesn't rise to your wonder about never retrieved. mwf -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Cary Millsap Sent: Wednesday, August 11, 2004 7:52 AM To: oracle-l@xxxxxxxxxxxxx Subject: RE: Is it just me Read-mostly, I'd say by 5:1 or greater in most cases. If you ever saw a system that was write-mostly over the long term, then there's data going in that's never coming out. You'd have to wonder why someone would pay money to store things that are never retrieved. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com * Nullius in verba * Upcoming events: - Performance Diagnosis 101: 9/14 San Francisco, 10/5 Charlotte - SQL Optimization 101: 8/16 Minneapolis, 9/20 Hartford - Hotsos Symposium 2005: March 6-10 Dallas - Visit www.hotsos.com for schedule details... -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Nuno Souto Sent: Wednesday, August 11, 2004 6:03 AM To: oracle-l@xxxxxxxxxxxxx Subject: Re: Is it just me Niall Litchfield apparently said,on my timestamp of 11/08/2004 8:52 PM: > Directories - read more frequently than written > Relational Databases - written more frequently than read. > > My experience of RDBMS systems is just the opposite. So do folk agree > with the generalisation abve, or do you consider databases to be a > read-mostly environment? > Read-mostly. By far. -- Cheers Nuno Souto in sunny Sydney, Australia dbvision@xxxxxxxxxxxxxxx ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------