openerp-india team mailing list archive

[Numérigraphe <1021321@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

On our modest database containing (66000 invoice lines, 1200 products, 3
partners), the Invoice Analysis takes so long to execute that the client
times out.

As it turns out,  "explain select * from account_invoice_report"
estimates the cost to 1009607118.61, which is really huge.

I tried to backport the latest report from the trunk, which is a bit
better but still far to costly to be usable. explain estimates the cost
to 734148039.28 - an order faster than v6, but still far from usable.

This query has far to many refinements in my opinion, and it should be
drastically simplified by dropping or optimizing costly computations.
Features like currency rate conversion, delay to pay, residual amount
seem to be complex beyond reason - but a finer analysis is needed to
confirm this.

Lionel Sausin.

** 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/1021321

Title:
  SQL query in invoice analysis is too complex

Status in OpenERP Addons (modules):
  New

Bug description:
  On our modest database containing (66000 invoice lines, 1200 products,
  3 partners), the Invoice Analysis takes so long to execute that the
  client times out.

  As it turns out,  "explain select * from account_invoice_report"
  estimates the cost to 1009607118.61, which is really huge.

  I tried to backport the latest report from the trunk, which is a bit
  better but still far to costly to be usable. explain estimates the
  cost to 734148039.28 - an order faster than v6, but still far from
  usable.

  This query has far to many refinements in my opinion, and it should be
  drastically simplified by dropping or optimizing costly computations.
  Features like currency rate conversion, delay to pay, residual amount
  seem to be complex beyond reason - but a finer analysis is needed to
  confirm this.

  Lionel Sausin.

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/1021321/+subscriptions