Re: Designing database tables for performance?

From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Mon, 19 Feb 2007 13:03:38 GMT
Message-ID: <KehCh.8254$R71.127461@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?

> When tables get that big the data is rarely in memory and so while
> perhaps some of the indexes will be, I have to say physical
> performance assuming reads from disk. Seems like I got some good
> ideas from the posts, in a few weeks I will mock it up and see how it
> flies with the various options.
Received on Mon Feb 19 2007 - 07:03:38 CST