Best approach to load data on page click

the_champ

Hello!
I am loading thousands of rows in Datatables which is very slow if possible at all. So, what I want to achieve is to divide the query in to pieces and when a user clicks on a page number to load the next portion of data.

I know about the $("#table_id").on( 'page.dt'); event, but I am wondering if there is a common approach in these cases. I have to preserve the page number, and then when adding the new rows to the table, I have to redraw the table setting the page number or there is a better solution?

Thanks!