Hi Odoo Community,

We are trying to better understand real-world performance challenges in Odoo, especially around slow report generation and frequently accessed data.

* Have you experienced slow report loading (e.g., accounting reports, inventory reports, dashboards)?

* Do certain models or data (like products, partners, stock data, or accounting entries) feel consistently slow to read, especially under repeated access?

* Does performance degrade when multiple users are accessing the same data or reports at the same time?

In many cases, these delays seem to come from repeated database reads of the same frequently used data.

We would like to understand:

* Which types of reports or models are most affected in your system?

* Does performance improve after repeated access (e.g., first load is slow, subsequent loads are faster)?

* Have you tried any optimizations (e.g., indexing, query tuning, increasing RAM, caching at application level, etc.)?

We are also exploring whether database-level improvements could help in such scenarios.

One idea is to automatically optimize how frequently accessed data is handled in memory, so that commonly used models and reports can be retrieved faster without repeated disk reads.

Your feedback and real-world experiences will help us better understand how common this issue is and what kind of solutions would be most useful.

Thank you!