From: | "Webb Sprague" <webb(dot)sprague(at)gmail(dot)com> |
---|---|
To: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
Cc: | "Simon Windsor" <simon(dot)windsor(at)cornfield(dot)me(dot)uk>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Performance of views |
Date: | 2008-11-03 00:07:55 |
Message-ID: | b11ea23c0811021607o2cdbad03j87fd226839eb77a1@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>> Am I right to avoid to VIEWS within application code?
How one uses views is more a matter of taste and best practices, than
a matter of rules like this. Frankly, this "rule" sounds rather ill
conceived.
My feeling is that views can be difficult to maintain when they are
nested, but otherwise use them whenever they simplify matters. I also
feel that they should only be defined for when they represent, well,
views of the data that make sense in a long term way; don't use them
if for a one-off application.
As for performance -- let me reiterate: create the most elegant
design, possibly with views, and only worry about performance AFTER
PROFILING.
-W
From | Date | Subject | |
---|---|---|---|
Next Message | Sam Mason | 2008-11-03 00:44:14 | Re: Are there plans to add data compression feature to postgresql? |
Previous Message | Sam Mason | 2008-11-02 23:58:05 | Re: defining an existing Table Schema for Foreign Key Constraint - Question |