Hello there....i have seen this question before, I cannot exactly remember when but it was a while ago. My advice is to go to the mysql.com website and do a search thru the mailing list using a search term something like "must execute query twice" or something to that effect. -sam
> Filesystem buffering? > > pow wrote: >> Hi everyone, >> Im puzzling over why a query loads faster the second time I execute it. >> >> I am sure it is not query cached, because that is off. >> I also made sure that the key that is used was already cached b4 i even >> executed the query the first time. So it is not like as if the 2nd >> execution used the key cache and the first attempt did not. >> >> I am executing the queries directly in MYSQL command prompt. >> >> >> Is there some other type of cacheing that i am missing? >> >> Thanks! >> >> Pow >> > > > -- > 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]