Hello! Obviously many concepts of OpenERP will fail if the amount of data becomes large (some million records) for this we will mateialized views (typically account_move_lines, stock_moves, SO/PO lines, timesheet lines etc)
another way to go could be to integrate OLAP concepts like http://packages.python.org/cubes/ (have not analyzed details) which are made exactly for analysis of data -- You received this bug notification because you are a member of OpenERP Accounting Experts, which is subscribed to the bug report. 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 _______________________________________________ Mailing list: https://launchpad.net/~openerp-expert-accounting Post to : [email protected] Unsubscribe : https://launchpad.net/~openerp-expert-accounting More help : https://help.launchpad.net/ListHelp
