Re: Designing database tables for performance?

From: DA Morgan <>
Date: Sat, 24 Feb 2007 11:25:41 -0800
Message-ID: <>

Cimode wrote:
> On 23 fév, 22:33, "jgar the jorrible" <> wrote:

>>> In what RAM would be less physical than HD ? For any reason, an
>>> absurdity is an absurdity.
>> Not an absurdity, you just aren't paying attention to how the I/O is
>> counted.

> So you say there are *ways* to count IO's. Fair enough. Question is:
> what has the way of counting IO's has any bearing on the media that
> supports them and therefore qualifies their nature as physical or
> logical? What is the difference: speed?
> Physical IO means that IO have some physical inmemory/hd counterpart
> while logical IO mean *no media* at all as a prerequisite.
>> From Oracle's point of view, if the desired data exists in
>> Oracle's buffers, that is a logical I/O.

> As I said, I am well aware of ORACLE brainwashing over its troops.
> ORACLE succeded to convince the audience of practictionners that RAM
> (call it cache if you want) = logical. One of Larry Ellison
> *contribution* to the field of database technology. Reading and
> educating yourself in RM will help you see the absurdity in that.

What I see is attitude rather than aptitude: Nothing more.

Daniel A. Morgan
University of Washington
(replace x with u to respond)
Puget Sound Oracle Users Group
Received on Sat Feb 24 2007 - 20:25:41 CET

Original text of this message