>
>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
f you get consistent times? What about running this directly through
the mysql cli?
Regards,
Gavin Towey
-Original Message-
From: Leo Siefert [mailto:lsief...@sbcglobal.net]
Sent: Thursday, August 13, 2009 1:10 PM
To: mysql@lists.mysql.com
Subject: Erratic query performance
I have a mod
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
I have a moderate sized database set up and a program that allows users to
create ad-hoc queries into the data based on entries in a form, so that I, as
the programmer, have control over the actual construction of the queries and
can do what is needed to optimize queries. I also keep a log of al