| From: | Simon Windsor <simon(dot)windsor(at)cornfield(dot)me(dot)uk> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Performance of views |
| Date: | 2008-11-02 23:11:52 |
| Message-ID: | 490E33B8.5060101@cornfield.me.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi
Generally, I have avoided using VIEWS within application code and only
used them for client interfaces, the sole reason being the performance
of views against tables.
Changes to database over the past few years appear to have improved the
performance of views, but I am still not comfortable with using VIEWS
within application code. The main reasons I have are
* Data within a view is not necessary sequential, unlike a table
* Higher overhead mapping to original tables and indexes
* Danger of linking views and tables and not utilising utilising
underlying tables properly.
Am I right to avoid to VIEWS within application code?
Simon
--
Simon
Simon Windsor
Eml: simon(dot)windsor(at)cornfield(dot)org(dot)uk
Tel: 01454 617689
Mob: 07960 321599
| From | Date | Subject | |
|---|---|---|---|
| Next Message | brian | 2008-11-02 23:14:06 | Re: Redefining an existing Table Schema for Foreign Key Constraint - Question |
| Previous Message | Brian714 | 2008-11-02 22:30:45 | Redefining an existing Table Schema for Foreign Key Constraint - Question |