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)
- 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:
- 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.
products.search(...).write(...)browse().*2many_product_ids.ids
More info about this on:
https://github.com/odoo/odoo/pull/61618
Table of contents
Usage
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.
Bug Tracker
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 to smash it by providing a detailed and welcomed feedback.
Do not contact contributors directly about support or help with technical issues.
Credits
Contributors
- Williams Estrada <williams@vauxoo.com> https://www.vauxoo.com/
- Moises Lopez <moylop260@vauxoo.com> https://www.vauxoo.com/
Other credits
This module was created and is maintained by:
- Vauxoo, S.A. de C.V.
Maintainers
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.
Current maintainers:
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.