Listing large table is slow

I have a 50m rows table. Viewing the resource list page/table is very slow. It takes at least 2-3 minutes to view the table. I believe there's a "count(*)" query for pagination, and this is causing the slowness. There are faster ways to count the rows. Can't I manually provide the total row count?
Was this page helpful?