openerp-india team mailing list archive

[GrtSrkn <1075633@xxxxxxxxxxxxxxxxxx>]

Hello Stefan,

I agree, it might be not the best way to fix this.
The only thing I have noticed is that all forms which use the product search field, and so the search more links, work at an acceptable speed after I've changed this in the core. And I didn't noticed a problem with missing products in my search results.

Only problem which I've detected, the POS is only loading 80 products.
Which seems to be obvious. So setting it to 100 will be also a problem I
assume ????

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