Dynamic table with pagination

I have created a question in ecosystem a week back but there is no response yet.

So, i am posting the same question here,

We are using the “Dynamic table” pagination which works fine only when we load it with all items. But, loading all items is not a good practice to proceed on.

What is the recommended way?