Hi Odoo Community,

We are trying to better understand real-world performance challenges in Odoo, especially when working with large datasets in list views.

One issue we are particularly interested in is slow pagination and navigation across large numbers of records.

•  Have you experienced slow loading when navigating through list views with many records?
•  Does moving to later pages (or jumping to the end of records) take significantly more time compared to initial pages?
•  Have you noticed that going backward or accessing the “last” records is slower than moving forward?

In many cases, this seems to happen when working with large models (e.g., accounting entries, stock moves, logs, etc.), where accessing certain parts of the dataset becomes increasingly slow.

We would like to understand:

•  Which models or screens are most affected in your system?
•  At what scale (number of records) does pagination start becoming slow?
•  Have you tried any optimizations (filters, indexing, archiving old data, etc.)?
•  Did those approaches help improve navigation speed?

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

One idea is to optimize how large datasets are accessed and navigated, so that moving across records (including last pages or reverse navigation) becomes faster and more consistent.

So we would like to ask:

•  Would you find value in improved pagination performance for large datasets?

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

Thank you!