increase the loading speed

cyashwanth

Hi all - i recently started using the datatables and its awesome. the problem i am having is when i have 9000 records loading in the table its taking 2:34 to load(including the query and processing the JSON and binding) i read about the deferrender, couldnt implement it.
$('.datatable').dataTable({

        "deferRender": true,
      "sPaginationType": "bs_normal",
      "iDisplayLength": 25,
      "bFilter": false,
      "blengthChange": false,
      "oLanguage": {
        "oPaginate":{
          "sPrevious": "Prev",
          "sNext": "Next"
        },
        "sInfo": "Results: _START_-_END_ of _TOTAL_ Providers",
      },
      "fnDrawCallback":function(){
        $(".datatable").css("width", "100%");
        $(".result-view").find(".pagination>.next").removeClass("hidden");
        $(".result-view").find(".pagination>.prev").removeClass("hidden");
        $(".result-view").find(".pagination>.disabled").addClass("hidden");
        $(".result-view").find(".pagination").find(".glyphicon").removeClass("glyphicon").addClass("icon-a");
        //Event handler for Details
        $(".info-window .icon-close").click(function(){
          $(".info-window").addClass("hidden");
        });

any help regarding this is greatly appreciated. thanks in advance

tangerine

There's a paragraph on speed in the FAQ: http://datatables.net/faqs/index

cyashwanth

added this line, "orderClasses": false and timed the response time its still 2 minutes and 34 secs. no change.

thanks for the quick response

ignignokt

If you use server side processing your table user experience will be like you have all 9000 rows loaded but it will actually only load whatever you can see at any point.