Re: Performance of views

Поиск
Список
Период
Сортировка
Искать
От
Scott Marlowe
Тема
Re: Performance of views
Дата
Msg-id
dcc563d10811021759o1f73f252h7237aa13fd267e94@mail.gmail.com
Ответ на
Re: Performance of views (Stephen Frost)
Список
Дерево обсуждения
Performance of views Simon Windsor <simon.windsor@cornfield.me.uk>
Re: Performance of views Stephen Frost <sfrost@snowman.net>
Re: Performance of views "Scott Marlowe" <scott.marlowe@gmail.com>
Re: Performance of views Tom Lane <tgl@sss.pgh.pa.us>
Re: Performance of views Russ Brown <pickscrape@gmail.com>
Re: Performance of views Martin Gainty <mgainty@hotmail.com>
Re: Performance of views "Scott Marlowe" <scott.marlowe@gmail.com>
Re: Performance of views "Nikolas Everett" <nik9000@gmail.com>
Re: Performance of views "Scott Marlowe" <scott.marlowe@gmail.com>
Re: Performance of views "Webb Sprague" <webb.sprague@gmail.com> 
On Sun, Nov 2, 2008 at 6:39 PM, Stephen Frost  wrote:
> Simon,
>
>>   * Higher overhead mapping to original tables and indexes
>
> This just plain isn't true in PG, at least, and I'd think most other
> sensible databases..

Note that, at least in older versions, MySQL completely materialized a
temporary table from a view, then used that for the view.  This is
horribly inefficient, and results in a lot of people thinking views
are slow.  Not sure if this has been addressed in MySQL yet, don't
really care anymore, since I rarely use mysql for anything anymore.
В списке pgsql-general по дате отправления
Предыдущее
От: Craig Ringer
Дата:
Следующее
От: Sam Mason
Дата:
FAQ