CODEWITHSUNDEEP
javascriptjquerydatatable
Talha Habib
Talha Habib

Reputation: 43

Jquery DataTable Dynamic Pagination

How can i configure Jquery DataTable to not load all content on first load

e.g if i have 1000 records, DataTable will load all in first load this can be heavy though. how about loading each content when click on pagination part? Like This

$(document).ready( function () {
  $('#example').dataTable( {
    "bServerSide": true,
    "sAjaxSource": "xhr.php"
  } );
} );

There is ServerSide configuration for alike pagination please let me know, if my question is duplicate just shout out.

Upvotes: 1

Views: 10647

Answers (2)

Sameer Kazi
Sameer Kazi

Reputation: 17359

Check here full jquery example jquery-datatable-ajax-tutorial-with-example

var studentTable;

jQuery(document).ready(function() {

studentTable = jQuery("#studentListTable").dataTable({
"bJQueryUI" : true,
"sPaginationType" : "full_numbers",
"bRetrieve" : true,
"bFilter" : true,
"iDisplayLength": 10,
"bProcessing" : true,
"bServerSide" : false,
"aoColumns" : [ { "bSearchable" : false,"bVisible" : false,
"asSorting" : [ "asc" ] },
{"sWidth" : "20%","bSortable" : true },
{"sWidth" : "20%","bSortable" : true },
{"sWidth" : "20%","bSortable" : true },
{"sWidth" : "20%","bSortable" : true },
{"sWidth" : "20%","bSortable" : true }
]
});

jQuery(".ui-corner-br").addClass("ui-widget-header_custom");
});

Upvotes: 0

pSaadi
pSaadi

Reputation: 300

Use the "deferLoading" attribute:

https://datatables.net/examples/server_side/defer_loading.html

Upvotes: 2

Related Questions