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: John Taylor||Date: 2002-06-12 15:07:26|
|Subject: Optimising inside transactions|
|Previous:||From: ben.carlyle||Date: 2002-06-11 23:35:08|
|Subject: Postgresql Historical data store|