Quoting Mikkel Høgh <m@ooh.dk>:
On Wed, May 6, 2009 at 8:17 PM, larry@garfieldtech.com <larry@garfieldtech.com> wrote:
If MySQL had built-in materialized views, then we could push the hard work on to the database and it would do that sort of pre-generation itself. Sadly it doesn't, so its "views" are really just syntax nicety.
Well, I don't know about MySQL, but in PostgreSQL there is actually a slight performance gain from using database views, in that it shaves off almost all the processing and query plan generation, so most of the steps besides executing the actual query are skipped when using a view.
You may also gain efficiency in the code which would reduce the processing time of PHP if a database view defines the common joins of the tables. -- Earnie -- http://r-feed.com/ -- http://for-my-kids.com/ -- http://www.4offer.biz/ -- http://give-me-an-offer.com/