openerp-india team mailing list archive

[Anders Wallenquist <anders.wallenquist@xxxxxxxxx>]

Public bug reported:

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.

** Affects: openobject-addons
     Importance: Undecided
         Status: New

-- 
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 sale 6.1

Status in OpenERP Addons (modules):
  New

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