>
>Any ideas of what could be causing the varied response time on a simple
query
>when everything on the server appears to be identical from one run to
another?
>Are there settings that can be made on the server to tweak response time
for a
>database/query like this?
>
[JS] Is it possible that ther
Hi Leo,
Also include the EXPLAIN SELECT ...; output, and the SHOW CREATE TABLE table\G
for each table used in the query.
Have you considered that your query's execution time depends on other activity
on the server? Have you tried skipping the cache ( SELECT SQL_NO_CACHE ... )
and see if you
In the last episode (Aug 13), Leo Siefert said:
> After playing around with the query in PhpMyAdmin I am totally perplexed
> as to what could be causing the problem. Sometimes the query will execute
> in less than 30 seconds, but other times it takes from 4 to 10 or more
> minutes. It never seem
