Performance and Loading Doubts

Performance and Loading Doubts

nagaraj123nagaraj123 Posts: 2Questions: 0Answers: 0
edited August 2012 in DataTables 1.9
[code]
var dTable = $('#pagination_table').dataTable( {
"bJQueryUI": true,
"sPaginationType": "full_numbers",
"iDisplayLength": 10,
"bProcessing": true,
"sAjaxSource": EnginePath + "/dictionary/getDictionaryList",
"bDeferRender": true,
"sAjaxDataProp": "Dictionary",
"aoColumns": [
{"mDataProp": "id","bVisible":false},
{"sTitle":"Test Code", "mDataProp": "code" },
{"sTitle":"Test Name", "mDataProp": "name" },
{"sTitle":"Loinc Code", "mDataProp": "loinc"},
{"sTitle":"Panel List", "mDataProp": function(obj){
if(obj.panel!=""){
return "View";
}else{
return "";
}
}
}
],

"fnDrawCallback": function(){
//Mouse pointer
$('#pagination_table tbody tr').hover(function() {
var data = dTable.fnGetData( this )
if((data!=null)&&(data.panel!="")){
$(this).css('cursor', 'pointer');
}
}, function() {
var data = dTable.fnGetData( this )
if((data!=null)&&(data.panel!="")){
$(this).css('cursor', 'auto');
}
});
}
});

// Get the Current id from the Data Table
$('#pagination_table tbody').delegate('tr', 'click', function(event) {

var data = dTable.fnGetData( this )
if((data!=null)&&(data.panel!="")){
if ( dTable.fnIsOpen( this) ) {
dTable.fnClose( this );
$(this).children().removeClass("highlight");
} else {
dTable.fnOpen( this, getPanelList(data.id) , "info_row" );
$(this).children().addClass("highlight");
}
}

});


//Mouse Over
$('#pagination_table tbody').delegate('tr', 'mouseover', function(event) {
$(this).children().addClass("highlight");
});

//Mouse Out
$('#pagination_table tbody').delegate('tr', 'mouseout', function(event) {

[/code]


My question is , if i have 50000 rows, the datatable will take much time for loading. Do we have any option to load 100 by 100 in back end side. Is there any solution we have, Kidly share your views and solutions.

Thanks,
Nagaraj T.

$(this).children().removeClass("highlight");
});

Replies

  • allanallan Posts: 63,498Questions: 1Answers: 10,471 Site admin
    See http://datatables.net/faqs#speed
This discussion has been closed.