diff options
| author | Sébastien Theys <seb@odoo.com> | 2019-07-16 08:38:10 +0000 |
|---|---|---|
| committer | Sébastien Theys <seb@odoo.com> | 2019-07-17 15:55:29 +0000 |
| commit | 5f87def82837e8e57a3f59cd8a3d2e960750fcd4 (patch) | |
| tree | 75f91d9817cdc20880354423bb13d643eebba3df /addons/web_editor/static | |
| parent | e12e936275097c97be28a3b191d14bc762d2eb1a (diff) | |
[IMP] website_sale: optimize category search
Use the pivot table instead of a mapping on all found products (which does not
scale well at all when there are many products found).
On a test case of 10000 products and 300 categories (including parent/children),
testing the /shop page with a search:
- number of queries from 138 down to 128 queries,
- total request time from 0.55s down to 0.40s
- time of the changed line from 32% of the total request time down to 10%
PR: #34249
Diffstat (limited to 'addons/web_editor/static')
0 files changed, 0 insertions, 0 deletions