[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Persistent connections to database?

Chris Travers wrote:

Also how big is the database?  How many rows in:  ar, ap, oe, invoice,
and acc_trans?

I ask because SQL-Ledger and hence LedgerSMB is known to have some
performance issues that we are still identifying and solving.
Furthermore, a lot more is going on in the db than just posting the
invoice.


tpb_db=> select count(*) from ar;
 count
-------
 50660
(1 row)

tpb_db=> select count(*) from ap;
 count
-------
  2951
(1 row)

tpb_db=> select count(*) from oe;
 count
-------
 44266
(1 row)

tpb_db=> select count(*) from invoice;
 count
--------
 148746
(1 row)

tpb_db=> select count(*) from acc_trans;
 count
--------
 479420


Charley