From: | bombadil(at)wanadoo(dot)es |
---|---|
To: | Lista PostgreSql <pgsql-general(at)postgresql(dot)org> |
Subject: | Views of views, complexity and speed. |
Date: | 2002-02-04 11:31:08 |
Message-ID: | 20020204113108.GA27350@fangorn |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Jason Earl | 2002-02-04 16:58:32 | Re: index does not improve performance |
Previous Message | Arsalan Zaidi | 2002-02-04 11:10:00 | Re: Distributing index's/tables/logs/etc. |