RE: Is it just me

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Wed, 11 Aug 2004 06:52:21 -0500
Message-ID: <00e001c47f99$aa08be00$9c2f190c@CVMLAP02>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Nuno Souto
Sent: Wednesday, August 11, 2004 6:03 AM To: oracle-l_at_freelists.org
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_at_optusnet.com.au
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://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_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Aug 11 2004 - 06:48:23 CDT