MySQL Forums
Forum List  »  Performance

Re: No caching - or brutal performance - for repeat queries 4.1.8nt
Posted by: James Day
Date: December 20, 2004 04:25PM

Are you perhaps including a comment in the SQL to identify the remote user? The query cache requires that the full text of the selec tbe identical, so something like ingcluding the IP address as acomment would block one user from seeing the improvement from cache operations done by others. Beyond that, what are the selects, or a representative select or two?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: No caching - or brutal performance - for repeat queries 4.1.8nt
1982
December 20, 2004 04:25PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.