How to use server side to retrieve all rows and have datatables not go to server for more

williamsdb

I have a very small data set of about 30 rows but it is very slow to generate the data for these rows. Therefore I am using server side to get the data so the front end shows "processing" to the client until the data is ready. This works well.

However, I am retrieving all the data at once and would like the table to be paginated showing only the first 10 rows. What happens now is that if you press next it tries to retrieve more data from the server side.

Is it possible to retrieve all data at once and have pagination applied and then turn off any further retrieval from the server?

I'm not sure if that makes sense but please ask if not!

Thanks

kthorngren

To retrieve all the data at once you would need to turn of the serverSide processing option. Once turned off you could try the deferRender option to if it helps in the display as noted in this FAQ. However if the delay is in the retrieval of the data versus rendering it to the page the deferRender might not help.

Kevin

williamsdb

@kthorngren thanks for the pointers. Taking out serverSide gives me exactly what I am looking for.