Customer vs Company

[Derek Atkins]

linas at linas.org (Linas Vepstas) writes:

> Maybe.  I added them as a performance thingy that should help
> perf in principle, but not clear by how much in practice.  
> The problem is that traditionally gnucash computes the balance
> by adding up *everything* since the very begining.  In SQL,
> it seemed like a waste to get *all* trnsactions just to compute
> the balance. Kind of defeats the purpose of having SQL. 
> 
> So instead I try to keep everything on the server, include a table of
> balance checkpoints.   For many users/big datasets, its a theoretical
> win.  In practice, with small datasets & an embedded db,  who knows,
> it may slow things down.

Yea.. I have no clue how much it actually improves the performance.  I
suspect that when we actually have accounting periods then it wont be
a major factor anymore -- we can just checkpoint the balances at the
beginning of every period and not worry about it within a period.  But
that means you don't need a stored procedure -- the checkpoint is
created as part of the 'close of period' functionality.

Anyways, I'm waiting for Matthew's new SQL code before even attempting
to experiment.

> --linas

-derek

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available