> 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
