Skip site navigation (1) Skip section navigation (2)

Re: How efficient are Views

From: "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk>
To: 'John Taylor' <postgres(at)jtresponse(dot)co(dot)uk>,PgSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: How efficient are Views
Date: 2002-06-12 15:21:15
Message-ID: E2870D8CE1CCD311BAF50008C71EDE8E01F748E5@MAIL_EXCHANGE (view raw or flat)
Thread:
Lists: pgsql-novice
A view just re-executes the query.
Therefore a view is as efficient as the query it's based upon :)
hth,
- Stuart

> -----Original Message-----
> From: John Taylor [mailto:postgres(at)jtresponse(dot)co(dot)uk]
> 
> Hi,
> 
> I'm thinking about using a view for my application.
> 
> However, I'm wondering about how efficient it will be once I 
> have a large amount of data
> loaded.
> 
> Are views generated for every access ?
> Are they generated when the underlying data changes ?
> 
> Whould it maybe be faster to have a seperate table alongside 
> the base data, and
> generate it via a trigger or stored procedure ?
> 
> Thanks
> JohnT

pgsql-novice by date

Next:From: Henshall, Stuart - WCPDate: 2002-06-12 15:24:40
Subject: Re: Optimising inside transactions
Previous:From: John TaylorDate: 2002-06-12 15:07:26
Subject: Optimising inside transactions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group