Slow when working with large (5000 rows) data using aaData

Slow when working with large (5000 rows) data using aaData

kulkarni_ashkulkarni_ash Posts: 35Questions: 8Answers: 0

HI
I have a data in json about 5000 rows, i am using aaData to create table, this json comes from form build.
How can i improve performance, i already have added deferRender=true,
Here is the actual code

var oTable1 = $j('#gridTblNew').dataTable(
                    {
                        "aaData":data1,
                    "deferRender": true,
                    "bPaginate": true,
                    "bSort": true,
                    "bSortClasses": false,
                    "bProcessing": true,
                    "bDeferRender": true,
                
                    "aoColumns":columns
                    } ); 

what else can i do to improve performance

Replies

  • kulkarni_ashkulkarni_ash Posts: 35Questions: 8Answers: 0

    Looks like this issue is with IE 8 and IE 11, in firefox and chrome it is ok

  • dylanmacdylanmac Posts: 49Questions: 7Answers: 1

    use the most recent version of datatables for starters.

  • kulkarni_ashkulkarni_ash Posts: 35Questions: 8Answers: 0

    I am using 1.10.5 version, which is pretty latest i believe

  • allanallan Posts: 61,771Questions: 1Answers: 10,112 Site admin

    Can you link to the page, as per the forum rules please, so we can profile it and see why it is running slow. IE11 should cope with 5k rows no problem.

    Allan

  • kulkarni_ashkulkarni_ash Posts: 35Questions: 8Answers: 0

    Hi
    This is intranet site, i have uploaded a test document on google drive and here is the link to download this page and try it out
    Let me know if you are not able to download, i could not upload to jsbin etc as the html file is to big

    https://drive.google.com/file/d/0B3IvZTuUdEgtZnhxaVNwX0Jqck1wTUhKYk13dVlkU0JHQ3A4/view?usp=sharing

This discussion has been closed.