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 по дате отправления: