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 michael.mcmahon@stripped
ActiveWire 410-547-8277 x610
| Thread |
|---|
| • query cache derived table | Mike McMahon | 17 Oct |
