openerp-india team mailing list archive

[GrtSrkn <1075633@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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.

** Affects: openobject-addons
     Importance: Undecided
         Status: New

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

Status in OpenERP Addons (modules):
  New

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