More than likely, the OS file system is caching the files that make up the
tables.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Ratheesh K J [mailto:[EMAIL PROTECTED]
Sent: Wed
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