Re: Designing database tables for performance?
From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 24 Feb 2007 11:25:41 -0800
Message-ID: <1172345140.974740_at_bubbleator.drizzle.com>
> 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.
>
> 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.
Date: Sat, 24 Feb 2007 11:25:41 -0800
Message-ID: <1172345140.974740_at_bubbleator.drizzle.com>
Cimode wrote:
> On 23 fév, 22:33, "jgar the jorrible" <joel-ga..._at_home.com> 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 damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Sat Feb 24 2007 - 20:25:41 CET