Skip to main content

Speedup product retrieve

Project description

Production/Stable License: LGPL-3 OCA/product-attribute Translate me on Weblate Try me on Runbot

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.
  • 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 smashing it by providing a detailed and welcomed feedback.

Do not contact contributors directly about support or help with technical issues.

Credits

Authors

  • Vauxoo

Contributors

Other credits

This module was created and is maintained by:

  • Vauxoo, S.A. de C.V.

Vauxoo, S.A. de C.V.

Maintainers

This module is maintained by the OCA.

Odoo Community Association

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:

WR-96 moylop260 luisg123v

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.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distribution

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page