Re: Designing database tables for performance?

"Bob Badour" <bbadour_at_pei.sympatico.ca> wrote in message news:KehCh.8254$R71.127461_at_ursa-nb00s0.nbnet.nb.ca...
> Timasmith wrote:
>
> > On Feb 18, 8:00 pm, "Mike Preece" <mich..._at_preece.net> wrote:
> >
> >>On Feb 9, 5:04 am, "Timasmith" <timasm..._at_hotmail.com> wrote:
> >>
> >>Are you interested in logical or physical performance?
>
> Oh my! Can anyone imagine anything more embarassing than Mike's
> question? Should we all point and laugh now?
>

Two points.

First, Mike's a Pickie. Enough said.

Second, the term "logical vs physical" has been used in many different ways by many different respectable people in the industry. In the documentation for one ancient DBMS, a so-called "logical I/O" was a reference to a buffer in memory,
while a "physical I/O" was a retrieval of a buffer's worth from disk. Received on Mon Feb 19 2007 - 07:30:19 CST