Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Designing database tables for performance?

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@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.org
Received on Sat Feb 24 2007 - 13:25:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US