[Maria-developers] query cache restrictions
24 May
2013
24 May
'13
11:35 p.m.
hi guys, why we can't cache "union" queries with query cache? http://www.mysqlperformanceblog.com/2006/07/27/mysql-query-cache/ *Caching full queries only *– Meaning it does not work for subselects, inline views, parts of the UNION. This is also common missunderstanding. -- Roberto Spadim
24 May
24 May
11:39 p.m.
sorry, found the problem... i tested the query select * from test.a where a =2 and b in(select a as a from test.a)union select * from test.a where a =2 and b in(select a as a from test.a) but it was not cached, i put the SQL_CACHE and i found it in query cache =] very nice =)
4262
Age (days ago)
4262
Last active (days ago)
1 comments
1 participants
participants (1)
-
Roberto Spadim