[Maria-developers] query cache restrictions
25 May
2013
25 May
'13
1:35 a.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
25 May
25 May
1:39 a.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 =)
4181
Age (days ago)
4181
Last active (days ago)
1 comments
1 participants
participants (1)
-
Roberto Spadim