Re: run query second time

2004-02-24 Thread Nitin Mehta
that's called, cache-hit - Original Message - From: "Matt W" <[EMAIL PROTECTED]> To: "Mike Mapsnac" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, February 24, 2004 5:25 AM Subject: Re: run query second time > Hi Mike, > >

Re: run query second time

2004-02-23 Thread Matt W
Hi Mike, - Original Message - From: "Mike Mapsnac" Sent: Monday, February 23, 2004 5:49 PM Subject: run query second time > Hello > > Today I run large query. It took more than 1 minute to start printing the > results. The output was about 5 rows. However

run query second time

2004-02-23 Thread Mike Mapsnac
Hello Today I run large query. It took more than 1 minute to start printing the results. The output was about 5 rows. However, when I run the query second time it took a couple of seconds before printing the results. Why is that? Because data still in the RAM? Thanks