Backoffice is slow due to count all with millions data for Pagination

[Former Member]

Dear team,

Pagination in BO so the query will execute twice, one for result, another on for count to serve pagination. Can we off pagination? just display 1 page with 20 items for example. If there is no configuration? Could show me how to customize?

p/s Hopefully, there is someone response my question 🙂

Regards, .

[Former Member]

Hi Tuy,

Its not good your's idea 'off pagination'.Must need pagination while fetching millions of records.U can reduce page size to improve performance.

[Former Member]

Thanks for your response. "off pagination" does not mean will show all of records. I meant just display 1 page with 20 items per that page. It should just fetch 20 items. And without pagination for all of remaining pages.--> This query is taking long time. The purpose is avoid executing count query for pagination.

Thanks