: Wednesday, August 23, 2006 7:02 AM
To: mysql@lists.mysql.com
Subject: Query takes different times for execution...
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
When a query goes from 18 to 10 seconds, or similar times, it is likely
because of caching at the MySQL or OS/disk level, not query caching. The
first time, the info had to be found on the disk and read, which is
relatively slow. After that it's in memory and can be accessed more quickly
in the
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
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
