The comments on bug #932524 certainly have a point: the currency rate feature
is really dubious.
But even when I remove it, the query tiles out on our database (66000 invoice
lines, 1200 products, 3 partners).
So there is probably more optimization work to do.
Lionel.
** Summary changed:
- Performance issue in sale 6.1
+ Performance issue in invoice analysis
** Changed in: openobject-addons
Status: New => Confirmed
--
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/1000195
Title:
Performance issue in invoice analysis
Status in OpenERP Addons (modules):
Confirmed
Bug description:
The sale-module produces a lot of selects to the
account_invoice_report database view. I think its one of the widget in
the dashboard that does this. Anyway the performance are lousy and a
ticking bomb for many 6.1 installations.
This select takes 8000 ms with 450 invoices in the database
SELECT month,price_total FROM "account_invoice_report" WHERE
account_invoice_report.id IN (450 ids)
The company creats over 200 000 invoices per year, which was OK with
series 5 of OpenERP. It will not be possible now after upgrade to 6.1.
There are many installations who creates more than 400 invoices per
year, many that creats 400 invoinces per day.
I think we need a temporary table or something instead of this
database view. Every time a salesman opens his saleview he hits this
problem.
To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/1000195/+subscriptions
_______________________________________________
Mailing list: https://launchpad.net/~openerp-india
Post to : [email protected]
Unsubscribe : https://launchpad.net/~openerp-india
More help : https://help.launchpad.net/ListHelp
