Hi ... I have the same problem.. In my system with 200 categories with 4 levels, the system performance is really really bad..
-- 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/1015450 Title: [6.1/trunk] Slow product price list Status in OpenERP Addons (modules): Confirmed Bug description: Hey, Fetching a product list (80) based on a pricelist, it's slow because of the the amount of product categories. Ex. - All Product - Import Supp001 Category - Import Supp002 Category - Import Supp003 Category - Import Supp004 Category ==> with around a total of 2400 categories in product/pricelist.py --> function "price_get_multi" > line 185: # product.category: product_category_ids = product_category_obj.search(cr, uid, []) product_categories = product_category_obj.read(cr, uid, product_category_ids, ['parent_id']) product_category_tree = dict([(item['id'], item['parent_id'][0]) for item in product_categories if item['parent_id']]) ==> this will always fetch all categories for each product in the list and is used to get the parents categories of the product which is used then in "_create_parent_category_list" (line 137) and slow downs the list. Possible fix is: We have then disabled the full search of the categories and rewrite the "_create_parent_category_list" function; >>> def _create_parent_category_list( categ_id, lst ): if not categ_id: return [] category = product_category_obj.browse( cr, uid, categ_id ) if category.parent_id: lst.append( category.parent_id.id ) return _create_parent_category_list( category.parent_id.id, lst ) return lst # _create_parent_category_list maybe not the best solution, but we go from 15sec -> 1.4 sec for fetching the list. RevNo: - Addons : 6850 - Web : 2364 - Server : 4212 To manage notifications about this bug go to: https://bugs.launchpad.net/openobject-addons/+bug/1015450/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~openerp-india Post to : [email protected] Unsubscribe : https://launchpad.net/~openerp-india More help : https://help.launchpad.net/ListHelp
