Views of views, complexity and speed.
| От | bombadil@wanadoo.es |
|---|---|
| Тема | Views of views, complexity and speed. |
| Дата | |
| Msg-id | 20020204113108.GA27350@fangorn обсуждение исходный текст |
| Ответы |
Re: Views of views, complexity and speed.
|
| Список | pgsql-general |
Hello list.
I have a question about complexity of queries and performance. I only
look for qualified opinions and comments.
In my database I have a pool of tables and views with rules for
inserting, updating and deleting.
In order to avoid complexity, some views looks in other views and
join them for getting data.
I see queries against that views result slower than queries against
plane tables or simple views by an order of magnitude (when not two).
My question is: if I would make complex views looking in plain tables
instead of other views, could I gain speed with the cost of more
difficult maintainability and readability?
Sorry for lazy data and arguments. If any of you think that detailed
tables and views may help, i can send them without problem.
Thanks for any opinion.
David
В списке pgsql-general по дате отправления: