Controling number of records returning from database but save number of pages and total number

Controling number of records returning from database but save number of pages and total number

yh3yh3 Posts: 1Questions: 1Answers: 0

Hi, I'm using jQuery DataTables and it's working but my problem is that the partition of records is on the client side so if the client have 1 million records it will be too slow, I had the idea to retrieve from database 10000 of records for each 10 pages for ex. and when I reach the page 10 I will retrieve from database the second 10000... If I do this:
First: how can I access the page number from this jQuery
Second: I want to save the real total number of pages in the info part and the pages number of the paging part (ie. showing 100 to 200 records from 1million record and not from 10000 records).
Any help is highly appreciated.
Thanks in advance.

This discussion has been closed.