Re: Designing database tables for performance?

On 24 Feb, 13:30, "Cimode" <cim..._at_hotmail.com> 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?
>

 Yes. A logical I/O does not go down an I/O channel but comes via the memory bus.

 The time to complete is therefore far less and the "cost" in terms of time is much less. Received on Mon Mar 05 2007 - 22:59:04 CST