Subject sum performance
Author reynaldi81
hi, i have this table to record all customer transactions from sales
to payments. is it better to update customer balance each time
transaction happens in a field or simply using sum? currently i stored
the customer balance in a ARBALANCE field and update it each time the
customer have transaction because i think that using sum will reduce
performance if i have huge numbers of records. does anyone have any
suggestions? thanks