How to Render Fast ? 100 records slow :(

apo

HI,

I have developed Datatables but more records I have more slower becomes datatable. My implementation is

table = $('#mytable').DataTable({

    "sPaginationType": "full_numbers",
    "bJQueryUI": false,
    "bAutoWidth": false,
    "bLengthChange": false,
    "bProcessing": true,
    "bServerSide": true,  
    "bFilter": false,
    "stateSave": true,
    "stateLoadParams": function (settings, data) {
        data.length = $("#custom_page_limit").val() ? parseInt($("#custom_page_limit").val()) : parseInt(app.page_limit);
        return true;
    },
    "bPaginate": true,
    "iDisplayLength": $("#custom_page_limit").val() != '-1' ? parseInt($("#custom_page_limit").val()) : parseInt(app.page_limit),
    "sAjaxSource": app.url.prefix + $("#grid_action_url").val(),

the grid_action_url is a url to php file where I collect my data.

When I have 4.000 records it takes about a minute to load the datatable. Would like to have your assistance to improve the performance. At least 12 columns

Thanks

apo

Some statistics http://fs5.directupload.net/images/151218/rexw6g2y.png

allan

Please link to a test case showing the issue, as per the forum rules.

Thanks,
Allan

apo

? How ? I am new here

allan

See the how to ask for help tech note.

Allan