MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

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?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
No caching - or brutal performance - for repeat queries 4.1.8nt
3651
Ed Tilley
December 20, 2004 12:14PM
Re: No caching - or brutal performance - for repeat queries 4.1.8nt
2266
James Day
December 20, 2004 04:25PM
Re: No caching - or brutal performance - for repeat queries 4.1.8nt
2277
Ed Tilley
December 23, 2004 12:19PM
Re: No caching - or brutal performance - for repeat queries 4.1.8nt
2199
James Day
December 23, 2004 02:50PM
Re: No caching - or brutal performance - for repeat queries 4.1.8nt
2240
Ed Tilley
December 28, 2004 01:58AM
Re: No caching - or brutal performance - for repeat queries 4.1.8nt
2253
Andr Schršder
December 28, 2004 03:55PM
Re: No caching - or brutal performance - for repeat queries 4.1.8nt
2276
Peter Zaitsev
December 31, 2004 07:17PM


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.