Database VIEWs - like a cache?
Moderator: General Moderators
Database VIEWs - like a cache?
I've trawled through the MySQL manual but I can't find an answer to this - is a VIEW cached and just updated when one of the tables in it is updated (with an INSERT, UPDATE, DELETE, etc)? I have a query that always features a very complicated subquery that never actually changes. Would changing the subquery to be a VIEW, and then just querying the VIEW be a good idea?
Re: Database VIEWs - like a cache?
From what I know MySQL doesn't support materialized views as of yet - this means the underlying select would be performed on each query involving the view.
Re: Database VIEWs - like a cache?
Hm, interesting question 
http://forums.mysql.com/read.php?100,53 ... #msg-53173
http://dev.mysql.com/doc/refman/5.0/en/ ... ithms.html
http://forums.mysql.com/read.php?100,53 ... #msg-53173
http://dev.mysql.com/doc/refman/5.0/en/ ... ithms.html
There are 10 types of people in this world, those who understand binary and those who don't