How can we improve data table load time?

How can we improve data table load time?

maheemahee Posts: 10Questions: 4Answers: 0

Hi I am pulling data from ajax source which is in flat txt file.
As the amount of rows increases in text file, data table take much time to load it.
I heard the server side processing but as i am getting data from the flat file I don't have any option to go with SSP.
is there any different method of static data storage, mongodb or something like.

Thanks in advance!

Answers

  • allanallan Posts: 54,528Questions: 1Answers: 8,526 Site admin

    See http://datatables.net/faqs/#speed .

    is there any different method of static data storage, mongodb or something like.

    Use whatever database on the server you want :-).

    Allan

  • maheemahee Posts: 10Questions: 4Answers: 0

    Allan Thanks,

    Do you have any idea where I can combine data table and HTML5 indexedDB.
    from indexedDB, can we load the data into datatable?

    Thanks,
    Mahee

  • allanallan Posts: 54,528Questions: 1Answers: 8,526 Site admin

    Sure, just get the data from your database and use rows.add() to add them to the table.

    Allan

  • maheemahee Posts: 10Questions: 4Answers: 0

    trying to add new row like

    table.row.add(
    {
    "column1": "Test1",
    "column2": "New Row Data"
    }
    ).draw();

    but table is not getting updated.
    Can you please point me where am I doing wrong?

  • maheemahee Posts: 10Questions: 4Answers: 0

    yes! got the new row.
    sorry it was my mistake. I was using dataTable() instead of DataTable().
    more regarding these two methods : http://datatables.net/faqs/#speed

This discussion has been closed.