* Betr.: " [tryton] Re: Performances issues with purchase-1.2" (Tue, 13 Oct 2009 21:25:28 +0200):
> > We are experiencing quite worrying performance issues with tryton-1.2,
> > especially on purchase and account_invoices modules.
> >
> > We have a database with about 2600 purchase orders and 45000 purchase
> > order lines.
> >
> > Reading 80 orders (1350 lines) takes more than 9 seconds (measured
> > with a script) for following fields: 'reference', 'untaxed_amount',
> > 'tax_amount' and 'total_amount'. The given time is taken after
> > executing several times the same script.
> >
> > Having a look on postgresql log, we saw numerous queries to
> > account_tax (always same 3 queries [1][2][3]): each one is called 2700
> > times.
>
> This is improved a lot on 1.3 with the cache on cursor.
> In my test, I have only one query of each kind for 10 purchase orders.
Just adding another experience from 1.3:
In a database with about 6000 parties I am experiencing a rather sluggish
display when browsing through the records, while searching for subsets is
tolerable.
Amazing fact is, that it is not only on forward browsing through the list, but
also backwards and it seems not to change. Shouldn't the already browsed data be
in the cache or how big is the cache?
--
Mathias Behrle
MBSolutions
Gilgenmatten 10 A
D-79114 Freiburg
Tel: +49(761)471023
Fax: +49(761)4770816
http://mbsolutions.selfip.biz
UStIdNr: DE 142009020
PGP/GnuPG key availabable from any keyserver, ID: 0x89BCA161
signature.asc
Description: PGP signature
