jQuery DataTables staggered loading

Question

I am looking to load a large dataset from server into the jQuery DataTables (thousands of rows with about 20 to 30 columns)

Instead of loading the entire data on one go, I would like to load the table chunk by chunk. Make an ajax call fetch back a few hundred rows and repeat, when the user scrolls down. Something like feeds on facebook and twitter. You scroll down, more ajax calls are fired and more data comes to the browser DOM and gets rendered.

I am exploring various options. One was I thought was using fnAddData() API as well as iDeferLoading. Has anyone done this before or has any other pointers that I can look up?

Jovan MSFT · Accepted Answer · 2011-10-27 19:20:28Z

2

Use server side processing where JQuery DatraTables send new ajax requests for each new page. Maybe you can also use infinite scrolling. Configuration shoudl look like:

$('#example').dataTable( {
    "bServerSide": true,
    "sAjaxSource": "../server_side/scripts/server_processing.php"
    sScorollX: "300px", 
    sScrollY: "200px"
    bScrollInfinite:true //this property disables pagination
} );

You can find more details on the DataTables site.

Jovan

answered Oct 27, 2011 at 19:20

Jovan MSFT

14.8k4 gold badges44 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

jQuery DataTables staggered loading

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related