Hello,
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.
For now, our workaround is too hide amount fields on trees to keep
acceptable user experience.
For information, the given results are for a server ran on Debian 5.0,
with Core 2 Duo 2300MHz/512 Mb RAM. We have same results with a Ubuntu
9.04 with Core 2 Duo 2300MHz/3Gb RAM.
[1] SELECT date_trunc('', create_date) AS
create_date,"sequence","invoice_tax_sign","write_uid","create_uid","credit_note_base_sign","group","invoice_account","credit_note_tax_code","template","percentage","type","parent","company","invoice_tax_code",date_trunc
('', write_date) AS
write_date,"active","invoice_base_sign","credit_note_account","credit_note_base_code","credit_note_tax_sign","amount","invoice_base_code",id
FROM "account_tax" WHERE id IN (0) AND (((((("account_tax".company =
0)))) AND true));
[2] SELECT "account_tax".id FROM "account_tax" WHERE
(("account_tax".parent IN (0)) AND ("account_tax".active = E'')) AND
((((("account_tax".company = 0)))) AND true) ORDER BY
"account_tax".sequence ASC,"account_tax".id ASC;
[3] SELECT "description",id FROM "account_tax" WHERE id IN (0) AND
(((((("account_tax".company = 0)))) AND true));
--~--~---------~--~----~------------~-------~--~----~
[email protected] mailing list
-~----------~----~----~----~------~----~------~--~---
