> that's almost actually how the MySQL query cache works: the query
> cache
> lookup kicks in even before the query is parsed, to get maximum gain
> from cache hits.
>
> It does not just take the query text into account alone though,
> but also the current default database, protocol version,
> and character
> set/collation settings of the client session, asl all these may have
> an influence on the actual result values, too ...
Plus checking username is neccessary (otherwise any user could
retrieve a cache for a table lookup which is not permitted by other
users).
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp