openerp-india team mailing list archive
-
openerp-india team
-
Mailing list archive
-
Message #18408
[Bug 1075633] Re: [trunk] Adding products in quotes is too slow
Note that the suggested change breaks the API very hard, as we really
expect to receive all resources when we call this method with limit=0.
And since the official client library does not support named arguments,
the obvious workaround of leaving out the argument does not work when
you want to pass the context for instance.
However, If what Geert says is the case and all records are preloaded in
a many2one search widget, then would it perhaps make more sense to set
the default limit for this widget to 100 (same as the limit of
name_search) in the client instead of hardcoding this just for the
product model?
--
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/1075633
Title:
[trunk] Adding products in quotes is too slow
Status in OpenERP Addons (modules):
Confirmed
Bug description:
Hello,
Testing the Quote system in OpenERP 7.0
When you have a product database of some volume (our demo has 60.000 products), and you want to add product lines by using the search more function it can take more than 2 minutes before you get your search screen. This also affects other search more options on other screens than Quotes.
It seems that while opening the search popup all product data is being
loaded in advance. Questions is why? When we alter the code for it
(see below) it is working fast and still correct. Not sure why all
60.000 products should be loaded in advance.
Altered code (suggestion):
file: product.py
function: def search(self, cr, uid, args, offset = 0, limit = None, order = None, context = None, count = False)
added rule(737)
=> if not limit and not limit is None:
limit = 80
This way only 80 products are being loaded in advance, search in
complete database is still working.
To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/1075633/+subscriptions
References