Re: Slow select queries after update

[Geir Øyvind Vælidalo]

Aftab Khan Wrote:
-------------------------------------------------------
> Do you have query_cache enabled? When table
> content changes (e.g. update, insert, delete), all
> cached queries that use the table become invalid
> and are removed from the cache.
>
> You can verify, if query_cache is enabled. Execute
> following commands using MySQL client tool:
> SELECT @@GLOBAL.query_cache_type,
> @@GLOBAL.query_cache_size;

Thanks Aftab! This explains everything. The cache is on and there are really too many selects for this to work as fast as the customer wants when then cache is flushed.
I will have to rewrite the page in order to minimize the number of queries.
Thanks again!

Best regards,
Geir