A view just re-executes the query.
Therefore a view is as efficient as the query it's based upon :)
> -----Original Message-----
> From: John Taylor [mailto:postgres(at)jtresponse(dot)co(dot)uk]
> 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
> 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 ?
pgsql-novice by date
|Next:||From: Henshall, Stuart - WCP||Date: 2002-06-12 15:24:40|
|Subject: Re: Optimising inside transactions|
|Previous:||From: John Taylor||Date: 2002-06-12 15:07:26|
|Subject: Optimising inside transactions|