Re: [Ledger-smb-devel] Proposed Change for 1.3

2008-04-02 Thread richard
Quoting Chris Travers <[EMAIL PROTECTED]>: The major drawback is that anything which hits this field needs to join > against the (much-larger) acc_trans table. This means that there is a > performance cost in large installations where these fields are used (AP/AP > Reports, payment handling, etc

Re: [Ledger-smb-devel] Proposed Change for 1.3

2008-04-02 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 2 Apr 2008 13:56:28 -0700 "Chris Travers" <[EMAIL PROTECTED]> wrote: > The major drawback is that anything which hits this field needs to > join against the (much-larger) acc_trans table. This means that > there is a performance cost in large

[Ledger-smb-devel] Proposed Change for 1.3

2008-04-02 Thread Chris Travers
Hi all; One of the problems which occasionally happens for people trying to work with LSMB is that summary information can get out of date. This is expected to be a further issue for SQL-Ledger 2.8 migrations because of specifics on how that information is calculated. It seems to me that the bes