Skip to Content
Menu
This question has been flagged
1 Reply
3591 Views

Hi,

we have 85000+ products mainly because we have many variable for the same product. Multiple width, height and material which translate in a lot of product. Our problem is that with that when we try to make a search using the name field, it timeouts. I tracked down the psql request and when I run the request in the psql console, it never end. The request is the fallow:

SELECT "product_product".id FROM "product_product","product_template" WHERE ((product_product."active" = 'True') AND ((product_product."id" in ((SELECT res_id FROM ir_translation WHERE name = 'product.product,name' AND lang = 'en_US' AND type = 'model' AND value ilike '%SAM-A%') UNION (SELECT id FROM "product_product" WHERE "name" ilike '%SAM-A%'))) OR (product_product."default_code" ilike '%SAM-A%'))) AND (product_product.product_tmpl_id = product_template.id) AND (((product_template."company_id" in (1))  OR  (product_template."company_id" in (1)))  OR  product_template."company_id" IS NULL ) ORDER BY default_code,name_template limit 100

There's definitely a problem with the request. Anyone got suggestion?

EDIT:

I have been able to fix my problem by changing the code inside osv/expression.py

Avatar
Discard
Best Answer

I tried this fix and works very well. h_t_t_p_s://code.launchpad.net/~openerp-dev/openerp-web/6.1-opw-574218-xal/+merge/10737

Avatar
Discard
Related Posts Replies Views Activity
2
Dec 23
19965
1
Mar 15
3652
2
Mar 15
4161
1
Dec 23
20843
1
Jan 24
15229