I’m after a bit of guidance here if anyone can help. I’m writing an angular app which uses a directive for Jquery Datatables plugin.
Anyways I’ve got it all hooked up and working with no issues but I’ve run into a bit of a gotcha. My dataset runs to about 30,000 records and is growing all the time however when I make a call to the DSP it only returns the first 1,000 records. Now I know I can increase the limit but with the amount of data being returned the response will take to long to load and I don’t think trying to manipulate that many records in the DOM is really a good idea.
What I think I need to do is leverage the ServerSide processing capabilities of DataTables but I can’t seem to find any examples or documentation how I might go about this using a REST API such as Dreamfactory. Most of the examples seem to use a server side PHP script.
I think the gang at Dreamfactory have achieved something similar in the ‘Data’ section of the DSP admin panel. It seems they’ve run into some similar issues though as the live search only returns records it finds in the currently loaded set (until you click apply).
I’m also intrigued how they went about solving the pagination issues too. Chuncking the record count perhaps and using offset?