It sounds like query caching is working against you.
There are a variety of ways to get around it. While it'll be a PITA, you may want to have you script call `RESET QUERY CACHE` at the begining, and then include `SQL_NO_CACHE` in your SELECT statement(s).
I had thought that setting this in /etc/my.cnf (and restarting mysql) would disable the query cache:
set-variable = query_cache_type=0
I'll try the RESET as well, to make sure.
Actually, I just noticed that even after I restart mysql, the speed stays. That doesn't make any sense, maybe there is some other unknown factor influencing this.
At 11:39 AM 2/24/2004, [EMAIL PROTECTED] wrote:
Are you logging slow queries? Have you run an explain plan for the queries in question?
Yes, but the problem is more that I'm doing a number of not-super-fast queries, so the accumulated effect is slow, but each query generally isn't that slow.
Yes, I'm using explain... that's usually how I work on slow querys, run explain, try adding and index, etc. These queries already have indexes, but in some cases they aren't fast.
-bill
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]