openerp-expert-accounting team mailing list archive

["Ronald Portier \(Therp\)" <ronald@xxxxxxxx>]

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
Accounting Experts, which is subscribed to a duplicate bug report
(1021321).
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