Re: view and performance

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: view and performance
Дата
Msg-id 007a01c106d7$8b57b1c0$1001a8c0@archonet.com
обсуждение исходный текст
Ответ на view and performance  (Wei Weng <wweng@kencast.com>)
Список pgsql-sql
From: "Wei Weng" <wweng@kencast.com>

> Is there any gain on performance if you choose to create a view over a
> very complex query instead of running the query itself directly?

I *believe* views are pre-parsed so you gain that time. Can't believe you'd
notice much difference either way unless the query was very fast to execute.

- Richard Huxton



В списке pgsql-sql по дате отправления:

Предыдущее
От: "Richard Huxton"
Дата:
Сообщение: Re: Is function atomic?
Следующее
От: John Hasler
Дата:
Сообщение: Re: Is function atomic?