openerp-india team mailing list archive

[Numérigraphe <1075633@xxxxxxxxxxxxxxxxxx>]

I suggest you make a merge proposal.
Lionel Sausin.

** Summary changed:

- [trunk] Adding products in quotes is to slow
+ [trunk] Adding products in quotes is too slow

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