Quoting Mikkel Høgh <[email protected]>:
On Wed, May 6, 2009 at 8:17 PM, [email protected]
<[email protected]> 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/
