execute query in the last page with pagination

execute query in the last page with pagination

sabersaber Posts: 1Questions: 0Answers: 0
edited March 2012 in DataTables 1.9
Hello,

I want to retrieve 200 line from but I display just 10 line for page and when I'm in last page I load from DB other 200 line.
And sorted it for 200 line not for all DB.

for example I have 400 line in DB:
I would like execute 2 query in DB Limit 0,200 and 201,400.
and each query I have pagination and sort from this resulat and when I go in the last page I can execute query from Limit 201,400

Thank you

Replies

  • allanallan Posts: 61,446Questions: 1Answers: 10,054 Site admin
    Have a look at this example: http://datatables.net/release-datatables/examples/server_side/pipeline.html

    Allan
This discussion has been closed.