openerp-india team mailing list archive

["Amit Parik \(OpenERP\)" <amp@xxxxxxxxxxx>]

Hello DR Ferdinand,

I have read your bug report, But I am not able to totally understand it
means where you have faced the problem.

So would you please elaborate more information on this or provide the
proper steps.

Thanks and waiting for your reply!

** Changed in: openobject-addons
       Status: New => Incomplete

-- 
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/932524

Title:
  account invoice report: massive performance problems

Status in OpenERP Addons (modules):
  Incomplete

Bug description:
  IMHO produces a carthesian product

  account/report/ account_invoice_report.py
  row 166
                  res_currency_rate cr
                  where cr.id in (select id from res_currency_rate cr2  where (cr2.currency_id = ai.currency_id)
                  and ((ai.date_invoice is not null and cr.name <= ai.date_invoice) or (ai.date_invoice is null and cr.name <= NOW())) limit 1)

  there as some 4000 entries in res_currency_rate
  it never returns

  EXPLAIN sais it will return > 1mio records
  for 400 invoicese
  500 invoice lines

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