← Back to team overview

openerp-expert-accounting team mailing list archive

Re: [Bug 1000195] Re: Performance issue in invoice analysis

 

On 02/14/2013 10:18 AM, Normunds Vilcans wrote:
Look at the SAP ("what is already dead :)"), even they use deferred processing
in most cpu intensive tasks.
We discovered, for example, that with SKU's over 10000, existing Pricelist
functionality hurts very much -in general it is not usable- twenty seconds  for
each Salse Order line processing (while recalculating prices) is ridiculous.
I think some kind of Prices cache per pricelist should be implemented.

FYI, the pricelist performance issue is being worked on. It also greatly affects the loading times of the POS UI in 7.0, as the POS preloads and caches the prices for all products at once. There's a work-in-progress MP that refactors the pricelist calculations and brings down the time to load the POS UI with 28k products from 15min to 13s:

https://code.launchpad.net/~openerp-dev/openobject-addons/7.0-pos-performance-cbi
This should bring a noticeable boost to all pricelist computations, and if it works well it should be backportable to 6.1.

(Watch out, it's a WIP and needs cleanup because it currently breaks the API, but you might want to give it a test run if you're concerned about pricelist perf)


References