With release 10 many tables have been moved to flexi tables. In the past, the table did not support paged queries, the table paging did work only on the in-memory data.
This architecture does not scale well for tables that contain many rows or tables which sizes can grow unlimited. Examples are list of users, groups or learning resources.
The database provides the solution for this problem with limits, this was implemented in flexi tables in OO 10. However, the drawback is that the "show all" button is not available anymore. Many maintenance tasks are now difficult because the page size is hardcoded to something like 20 entries. If one has to manage 200 data objects this quickly get a big hassle.
The solution is to let the user configure the page size on a per table level. In uncritical tables, the user can also choose to show all.
- Configuration of page sizes. Default is 20, 50, 100, 200
- Option for "show all" where it can be implemented without danger
- Persitance of personal configuration the same way as the table colums configuration
- Resetting the table columns configuration does also reset the paging configuration