Noreh AD
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?
34 replies