Performance and Loading Doubts

nagaraj123

[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");
});

allan

See http://datatables.net/faqs#speed