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, > > > ----- 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 50000 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 > > Yep, that's usually why. :-) > > > Matt > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
