Customer vs Company

[Linas Vepstas]

On Thu, Apr 03, 2003 at 08:43:24PM -0500, Derek Atkins was heard to remark:
> linas at linas.org (Linas Vepstas) writes:
> 
> > XML is also good for network transport, and an earlier version of the XML
> > file format did just that.  It is useful for portability too; not all SQL
> > dialects are the same, and gnucash uses stored proceedures, which not
> > all databases handle well.  Archiveing too.   Old database backups
> > are often dangerous, useless, and unrestorable, and thus unsuitable 
> > for archiving.
> 
> I'm not convinced that Gnucash _NEEDS_ to use stored procedures --
> in particular for an embedded-db.

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.

--linas
> 

-- 
pub  1024D/01045933 2001-02-01 Linas Vepstas (Labas!) <linas at linas.org>
PGP Key fingerprint = 8305 2521 6000 0B5E 8984  3F54 64A9 9A82 0104 5933