Search 1.9 billion lines of Odoo code on GitHub
product_order_noname
<h1 class="title">Product Order No Name</h1>
<p><a class="reference external" href="https://odoo-community.org/page/development-status"><img alt="Production/Stable" src="https://img.shields.io/badge/maturity-Production%2FStable-green.png" /></a> <a class="reference external" href="http://www.gnu.org/licenses/lgpl-3.0-standalone.html"><img alt="License: LGPL-3" src="https://img.shields.io/badge/licence-LGPL--3-blue.png" /></a> <a class="reference external" href="https://github.com/OCA/product-attribute/tree/14.0/product_order_noname"><img alt="OCA/product-attribute" src="https://img.shields.io/badge/github-OCA%2Fproduct--attribute-lightgray.png?logo=github" /></a> <a class="reference external" href="https://translation.odoo-community.org/projects/product-attribute-14-0/product-attribute-14-0-product_order_noname"><img alt="Translate me on Weblate" src="https://img.shields.io/badge/weblate-Translate%20me-F47D42.png" /></a> <a class="reference external" href="https://runbot.odoo-community.org/runbot/135/14.0"><img alt="Try me on Runbot" src="https://img.shields.io/badge/runbot-Try%20me-875A7B.png" /></a></p>
<p>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.</p>
<p>Warning: This changes the way products are ordered
product are ordered "default_code, id"
instead of "default_code, translated(name), id"</p>
<p>Because Odoo needs the following query to get a translated(name)</p>
<pre class="code">
<code class="code">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</code>
</pre>
<dl class="docutils">
<dt>Using a production database executing this query the result is:</dt>
<dd><ul class="first last simple">
<li>Planning Time: 1.088 ms</li>
<li>Execution Time: 1027.282 ms</li>
<li>Total Time: 1028.37 ms</li>
</ul>
</dd>
</dl>
<p>It is so slow.</p>
<p>Using the new order: "default_code, id" the following query is executed now:</p>
<pre class="code">
<code class="code">SELECT "product_product".id
FROM "product_product"
WHERE ( "product_product"."active" = true )
ORDER BY "product_product"."default_code"
LIMIT 10</code>
</pre>
<dl class="docutils">
<dt>The new result is:</dt>
<dd><ul class="first last simple">
<li>Planning Time: 0.095 ms</li>
<li>Execution Time: 0.529 ms</li>
<li>Total Time: 0.624 ms</li>
</ul>
</dd>
</dl>
<p>It is 1.65k times faster</p>
<p>It is because the field <code>name</code> has the parameter <code>translate=True</code></p>
<p>So, It will process the original value to translate it</p>
<p>Then, It will order by a column computed on-the-fly of other tables</p>
<p>default_code is a column indexed so the result is faster</p>
<p>Opening the <code>/shop</code> page could consume 7.5s instead of 1.2s without this module</p>
<dl class="docutils">
<dt>Odoo is using the _order parameter even if you don't need it.</dt>
<dd><ul class="first last simple">
<li><code>products.search(...).write(...)</code></li>
<li><code>browse().*2many_product_ids.ids</code></li>
</ul>
</dd>
</dl>
<p>More info about this on:</p>
<blockquote>
<a class="reference external" href="https://github.com/odoo/odoo/pull/61618">https://github.com/odoo/odoo/pull/61618</a></blockquote>
<p><strong>Table of contents</strong></p>
<div class="contents local topic" id="contents">
<ul class="simple">
<li><a class="reference internal" href="#usage" id="id1">Usage</a></li>
<li><a class="reference internal" href="#bug-tracker" id="id2">Bug Tracker</a></li>
<li><a class="reference internal" href="#credits" id="id3">Credits</a><ul>
<li><a class="reference internal" href="#authors" id="id4">Authors</a></li>
<li><a class="reference internal" href="#contributors" id="id5">Contributors</a></li>
<li><a class="reference internal" href="#other-credits" id="id6">Other credits</a></li>
<li><a class="reference internal" href="#maintainers" id="id7">Maintainers</a></li>
</ul>
</li>
</ul>
</div>
<a name="usage"></a>
<h2><a class="toc-backref" href="#id1">Usage</a></h2>
<p>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.</p>
<a name="bug-tracker"></a>
<h2><a class="toc-backref" href="#id2">Bug Tracker</a></h2>
<p>Bugs are tracked on <a class="reference external" href="https://github.com/OCA/product-attribute/issues">GitHub Issues</a>.
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
<a class="reference external" href="https://github.com/OCA/product-attribute/issues/new?body=module:%20product_order_noname%0Aversion:%2014.0%0A%0A**Steps%20to%20reproduce**%0A-%20...%0A%0A**Current%20behavior**%0A%0A**Expected%20behavior**">feedback</a>.</p>
<p>Do not contact contributors directly about support or help with technical issues.</p>
<a name="credits"></a>
<h2><a class="toc-backref" href="#id3">Credits</a></h2>
<a name="authors"></a>
<h3><a class="toc-backref" href="#id4">Authors</a></h3>
<ul class="simple">
<li>Vauxoo</li>
</ul>
<a name="contributors"></a>
<h3><a class="toc-backref" href="#id5">Contributors</a></h3>
<ul class="simple">
<li>Williams Estrada <<a class="reference external" href="mailto:williams@vauxoo.com">williams@vauxoo.com</a>> <a class="reference external" href="https://www.vauxoo.com/">https://www.vauxoo.com/</a></li>
<li>Moises Lopez <<a class="reference external" href="mailto:moylop260@vauxoo.com">moylop260@vauxoo.com</a>> <a class="reference external" href="https://www.vauxoo.com/">https://www.vauxoo.com/</a></li>
</ul>
<a name="other-credits"></a>
<h3><a class="toc-backref" href="#id6">Other credits</a></h3>
<p>This module was created and is maintained by:</p>
<ul class="simple">
<li>Vauxoo, S.A. de C.V.</li>
</ul>
<a class="reference external image-reference" href="http://www.vauxoo.com"><img alt="Vauxoo, S.A. de C.V." src="http://www.vauxoo.com/logo.png" /></a>
<a name="maintainers"></a>
<h3><a class="toc-backref" href="#id7">Maintainers</a></h3>
<p>This module is maintained by the OCA.</p>
<a class="reference external image-reference" href="https://odoo-community.org"><img alt="Odoo Community Association" src="https://odoo-community.org/logo.png" /></a>
<p>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.</p>
<p>Current <a class="reference external" href="https://odoo-community.org/page/maintainer-role">maintainers</a>:</p>
<p><a class="reference external" href="https://github.com/WR-96"><img alt="WR-96" src="https://github.com/WR-96.png?size=40px" /></a> <a class="reference external" href="https://github.com/moylop260"><img alt="moylop260" src="https://github.com/moylop260.png?size=40px" /></a> <a class="reference external" href="https://github.com/luisg123v"><img alt="luisg123v" src="https://github.com/luisg123v.png?size=40px" /></a></p>
<p>This module is part of the <a class="reference external" href="https://github.com/OCA/product-attribute/tree/14.0/product_order_noname">OCA/product-attribute</a> project on GitHub.</p>
<p>You are welcome to contribute. To learn how please visit <a class="reference external" href="https://odoo-community.org/page/Contribute">https://odoo-community.org/page/Contribute</a>.</p>