I'm using MySQL 4.0.13 for a web application, and one of my queries is
sufficiently complex such that it might take several seconds to return
the results to the user. I'd like to return a "please wait" page if the
query is not already in the cache. Is there a way (or a proposed way)
of doing a query, for example:
SELECT in_query_cache("STATEMENT") ? (Result: 0 if not in cache, 1 if
in cache)
Also, right now, it appears that the query cache treats as a cache miss
a statement whose only difference from a previously-cached statement is
a LIMIT clause. And so, it's actually faster for the application to
issue a query without a LIMIT clause, and then limit the results by way
of accessing only certain elements in the resulting array, than it is to
have MySQL do it for me. I propose that the cache be tunable so that
MySQL can cache the whole result set such that statements that vary only
in their LIMIT clauses are all treated as cache hits. RAM is cheap, so
it seems to be a reasonable suggestion.
--Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
