[GENERAL] View vs Constantly Updated Table

[Ketema Harris]

if i have a "column" that is a calculation, say a bank balance -> sum  
of all the debits and credits...is it more efficient to make a view  
that executes the underlying calc query doing the math, or to create a  
table that has a column called balance that is updated for each  
transaction?

so in the end "select balance from view" or "select balance from  
table" ?

What are the pros cons ?

Thanks

Ketema J. Harris
www.ketema.net
ket...@ketema.net
ketemaj on iChat
<<inline: kmail.png>>

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general