Performance issues with rendering

Performance issues with rendering

fanoffanof Posts: 2Questions: 0Answers: 0
edited June 2013 in DataTables 1.9
I am trying to render around 2500 rows with sorting disabled and "bDeferRender": true. and it's taking around 40s in chrome(v27). I am using Datatables 1.9 and jquery 2 . Any sugestions ?

Replies

  • allanallan Posts: 63,383Questions: 1Answers: 10,449 Site admin
    Link to a test case please: http://datatables.net/forums/discussion/12899/post-test-cases-when-asking-for-help-please-read

    Allan
  • fanoffanof Posts: 2Questions: 0Answers: 0
    edited June 2013
    Actually I can't provide a test case. but I can provide the settings for datatable. I computed the time took for datatable creation for every ajax call. It takes 188millisec for just 45 records. But for 2500 records its taking around 38 sec
    [code] 
    var oSettings = {
    'bDestroy': true,
    "bInfo": true,
    "bProcessing": true,
    "bDeferRender": true,
    'iDisplayLength': 10,
    'sPaginationType': 'full_numbers',
    'sDom': '<"top"i> T<"clear">lfrtip',
    'sPageButtonActive': "paginate_active",
    'sPageButtonStaticDisabled': "paginate_button",
    "oLanguage": {
    "sSearch": "Futher Filter Search results:",
    "sInfo": "Got a total of _TOTAL_ results to show (_START_ to _END_)",
    "sLengthMenu": 'Show ' +
    '5' +
    '10' +
    '15' +
    '20' +
    '25' +
    ' results'
    },
    "bSort": false

    };
    [/code]
  • allanallan Posts: 63,383Questions: 1Answers: 10,449 Site admin
    It looks like you are reading the table from the DOM - in which case deferred rendering will make no different. See http://datatables.net/faqs#speed .

    Also, it is the page that takes so long to load? DataTables should be easily coping with 2500 records.

    However, I'm afraid I can't offer any more help than that without a link and I'm simply guessing and don't have enough information to be able to offer any help.

    Allan
This discussion has been closed.