Re: Query Performance.

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Thu, 25 Jan 2001 18:20:29 GMT
Message-ID: <3a706e2b.1384985641@news.alt.net>

On Thu, 25 Jan 2001 14:28:29 GMT, Michael Bialik <michael_bialik_at_my-deja.com> wrote:

>Hi.
>
> It's quite possible that the response time improved because all data was
>loaded into memory by the first query. The second query used it without
>making actual I/O to disks.
>
> Michael.
>

Thank you, but I checked that out, or so I think. The times are after running each query a few times. The times kept gettinmg faster, but relative to each other, they were basically the same.

Brian Received on Thu Jan 25 2001 - 12:20:29 CST