On 8/23/06, Ratheesh K J <[EMAIL PROTECTED]> wrote:
Hello all,
I wanted to know why a select query takes ,say, 18 sec to execute the first
time I execute it and then for every successive execution it takes, say, 10 sec.
I have disabled Query Caching on the server. If its not Query Caching then what
else is causing this variation in exec time?
1) Also i would like to know something about table caching (what exactly gets
cached here?) and its advantages
2) What is an optimal join order. Should it be a smaller result joined with a
bigger one or vice-versa, Or how does MySQL do it?
The operating system can cache things.
If you run something like:
select id from table order by rand() limit 100;
that should clear the o/s cache.
Not sure about the other questions.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]