** Branch linked: lp:openobject-addons/6.1 -- 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): Fix Released 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
