How can we improve data table load time?

mahee

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!

allan

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

mahee

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

allan

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

Allan

mahee

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?

mahee

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