Обсуждение: view and performance

Поиск
Список
Период
Сортировка

view and performance

От
Wei Weng
Дата:
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?

Thanks!

-- 
Wei Weng
Network Software Engineer
KenCast Inc.




Re: view and performance

От
"Richard Huxton"
Дата:
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