Improve Performance of Large Datasets

Change default Pager to SimplePager

Default Pager is counting all rows in the table, so the user can navigate to any page in the Datagrid. But counting thousands or millions of records can be slow operation. If you don't need to know the number of all records, you can use SimplePager instead. It doesn't count all rows, but gives user only information if there is next page or not.

To use SimplePager in your admin, define pager_type in the service definition:

1
2
3
4
5
6
7

# config/services.yaml

services:
    app.admin.post:
        class: App\Admin\PostAdmin
        tags:
            - { name: sonata.admin, model_class: App\Entity\Post, manager_type: orm, group: 'Content', label: 'Post', pager_type: 'simple' }