[development] Database / SQL future thoughts

[Earnie Boyd]

Quoting Mikkel Høgh <m at ooh.dk>:

> On Wed, May 6, 2009 at 8:17 PM, larry at garfieldtech.com
> <larry at 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/