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_at_ursa-nb00s0.nbnet.nb.ca>
Date: Mon, 19 Feb 2007 13:03:38 GMT
Message-ID: <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:
Oh my! Can anyone imagine anything more embarassing than Mike's
>
>>On Feb 9, 5:04 am, "Timasmith" <timasm..._at_hotmail.com> wrote:
>>
>>Are you interested in logical or physical performance?
> 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 - 14:03:38 CET