Infinite scroll with Scroller

rogercbe

I want to implement a table that loads data when user reaches the end of the screen (table) to do so I'm using scroller together with server side ajax functionality, right now it loads all the data at once, and since it's quite a lot of data (thousands of records) it takes too much time. How could I load data the same way paginate works but with a scroll?

Those are my settings:

var table = $('#mytable').DataTable({
        order: [[ 1, "asc" ]],
        paging: false,
        processing: true,
        serverSide: true,
        pageLength: 20,
        responsive: true,
        ajax: '/some/api'
    });

allan

paging: false,

Remove that option. With paging disabled it will always load all of the records! That's why it is running to slow - its as if you didn't have server-side processing at all, so all it is doing is adding latency :-)

Allan

rogercbe

Thank you, after playing around I kind of found that out myself, I created a function to increase the page size everytime the user reaches the end of the screen, apparently it works just fine.

Again, thanks for the fast answer!