Benchmark

Success Story: Performance Optimization at a Mid-Sized Trading Company

Background

A mid-sized trading company with around 50 Odoo users reported increasingly long loading times in the purchasing and warehouse modules. Opening product lists and purchase order overviews caused noticeable delays of up to 8 seconds. The internal IT team had no clear indication of which fields or calculations were responsible for the performance drop.

Approach with odoo benchmark fields

Using the Zodoo Framework, the command odoo benchmark fields product.product and odoo benchmark fields purchase.order.line were run against the affected models. The tool systematically analyzed all fields of both models and measured their read times under real database conditions.

The results clearly showed that two computed fields on purchase.order.line – a custom field for the margin and another for the forecasted stock level – were being calculated extremely slowly on every database access. Both fields were missing the store=True attribute, causing them to be recalculated on every call instead of being cached.

Result

After updating both fields to store=True and running the benchmark again, the average load time of the purchase order overview dropped from 8 seconds to under 1 second. The diagnostic tool had pinpointed the issue within minutes – without lengthy manual debugging or expensive profiling setups.

Conclusion

odoo benchmark fields is an essential tool for fast and targeted performance diagnosis in Odoo projects. It allows developers and administrators to identify bottlenecks at the field level without diving deep into source code. Using it within the Zodoo Framework makes this process reproducible and traceable – ideal for continuous performance monitoring in production environments.

Example Command using curl

Grab the curl of the long loading view

odoo benchmark curl  # takes info from screenshot

Benchmark Run Output

Note: As an alternative, odoo benchmark fields can also be used directly on the console (e.g. odoo benchmark fields res.partner -u it@zebroo.de -p ‘********’), which is useful when direct RPC access with credentials is preferred over copying a cURL command from the browser.