Based on may observations, derived tables (subselect) are not cacheable: select column1, column2 from (select SQL_CACHE * from MyTable) as b
The second part is not inserted to QueryCache nor is it retrieved if already in
cache.
Also the file comments in sql_cache.cpp - Make derived tables cachable.
Can anybody help steer me to the general steps required to add this functionality?
Thanks
Sorry if I have duplicated my post, not sure if first attempt was delivered due to
spam controls.
-- Mike McMahon [EMAIL PROTECTED] ActiveWire 410-547-8277 x610
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]