This talk presents the best practices to write efficient code in Odoo, i.e., code that performs

reasonably well with large data sets.

Best practices are based on a good understanding of the ORM's underlying mechanisms.

Those mechanisms are flexible enough to support business code with good performance.

This knowledge will help developers to estimate the performance of design choices and

algorithms, and make a good choice given a situation. Each basic operation performs a certain

 number of database queries that determines the operation's time cost and performance.

The structure of the talk will be as follows:

- Reading records: cache, data prefetching and environments

- Creating, updating and deleting records

- Computed fields: computation, invalidation and recomputation

- Searching records