Database VIEWs - like a cache?
Posted: Fri Nov 13, 2009 3:17 am
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?