View vs Constantly Updated Table

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
ketema(at)ketema(dot)net
ketemaj on iChat