No amount of hardware is going to solve problems with bad design. These kind of queries should simply not be run on opening an application, like going to the sales module. Or should not be run at all, if hte information is needed, rewrite and redesign to get acceptabel performance, instead of hoping that throwing hardware at a problem will make it go away.
In the meantime people might be helped by the following branch, created by Akretion, that among other things allows to disable the sale dashboard: https://code.launchpad.net/~akretion-team/+junk/addons-no-fluff -- 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
