Product Order No Name
Speedup product retrieve
Product Order No Name
This module improves retrieving products when a language is installed and configured. The default behaviour is to order products by name, which in this case would be slow because Odoo will process the product's name to translate it.
Warning: This changes the way products are ordered product are ordered "default_code, id" instead of "default_code, translated(name), id"
Because Odoo needs the following query to get a translated(name)
SELECT "product_product".id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ( "product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id" ) LEFT JOIN (SELECT res_id, value FROM "ir_translation" WHERE type = 'model' AND name = 'product.template,name' AND lang = 'es_MX' AND value != '') AS "product_product__product_tmpl_id__name" ON ( "product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" ) WHERE ( "product_product"."active" = true ) ORDER BY "product_product"."default_code", Coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name"), "product_product"."id" LIMIT 10
- Using a production database executing this query the result is:
- Planning Time: 1.088 ms
- Execution Time: 1027.282 ms
- Total Time: 1028.37 ms
It is so slow.
Using the new order: "default_code, id" the following query is executed now:
SELECT "product_product".id FROM "product_product" WHERE ( "product_product"."active" = true ) ORDER BY "product_product"."default_code" LIMIT 10
- The new result is:
- Planning Time: 0.095 ms
- Execution Time: 0.529 ms
- Total Time: 0.624 ms
It is 1.65k times faster
It is because the field name has the parameter translate=True
So, It will process the original value to translate it
Then, It will order by a column computed on-the-fly of other tables
default_code is a column indexed so the result is faster
Opening the /shop page could consume 7.5s instead of 1.2s without this module
- Odoo is using the _order parameter even if you don't need it.
More info about this on:
Table of contents
Just by installing the module you should see a performance increase when retrieving products, from the website shop or the product's list view for example.
Bugs are tracked on GitHub Issues. In case of trouble, please check there if your issue has already been reported. If you spotted it first, help us smashing it by providing a detailed and welcomed feedback.
Do not contact contributors directly about support or help with technical issues.
This module was created and is maintained by:
- Vauxoo, S.A. de C.V.
This module is maintained by the OCA.
OCA, or the Odoo Community Association, is a nonprofit organization whose mission is to support the collaborative development of Odoo features and promote its widespread use.
This module is part of the OCA/product-attribute project on GitHub.
You are welcome to contribute. To learn how please visit https://odoo-community.org/page/Contribute.
Once the user has seen at least one product this snippet will be visible.