Jquery.data Tables are very slow, i.e. eleven

Question

The user reported a strange problem where, after upgrading to 11, jquery.dataTables runs very slowly (20-40 seconds) for rendering. About 400 results, which seems reasonable. And it works VERY fast in Chrome and FF.

After some diving, it turns out that any call to the table sorter causes a slow server.

We use 1.9.4, although attempts to upgrade to 1.10 also did not show any performance improvements.

The code is very simple:

$('#results_table').dataTable({
        "aoColumnDefs": [
            { "bSortable": false, "aTargets": [ 0, 1, 12 ] },
            { 'sType': 'currency', 'aTargets': [8] }
        ],
        "aaSorting": [[19, 'asc'], [18, 'asc'], [16, 'desc'], [4, 'desc'], [13, 'desc'], [5, 'desc'], [14, 'desc'], [15, 'desc'], [3, 'asc'], [6, 'desc']]
    });

Any thoughts on improvements would be welcome.

Answer 1

, . dataTables dom.

:

$('#results_table').dataTable({
  "aaData":[[attrs], [attrs]], // an array of row data
   "aaSorting": [[19, 'asc'], [18, 'asc']],
   "aoColumns": [
       { "sClass": "center" },
       //... other class definitions
    ]
});