Skip to Content
เมนู
คุณต้องลงทะเบียนเพื่อโต้ตอบกับคอมมูนิตี้
คำถามนี้ถูกตั้งค่าสถานะ
1 ตอบกลับ
3712 มุมมอง

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

อวตาร
ละทิ้ง
คำตอบที่ดีที่สุด

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

อวตาร
ละทิ้ง
Related Posts ตอบกลับ มุมมอง กิจกรรม
Using search count แก้ไขแล้ว
2
ธ.ค. 23
20152
1
มี.ค. 15
3823
2
มี.ค. 15
4265
What is 'better': search or browse? แก้ไขแล้ว
1
ธ.ค. 23
21077
1
ม.ค. 24
15449