Large CSV Data Table

bridrod

Hi, I have this code: https://bpa.st/FXAA which is working fine with smaller test CSV file, using this JS filter: https://bpa.st/PXCA.DataTables is working fine.
When I use a 50K line CSV, it takes too long to load the data and only after all is loaded (when browser doesn't crash), DataTables formats it.

I was wondering if the way I am doing is wrong or could be improved. Maybe filter display beforehand? Introduce another page to filter first? Sorry, I am not sure how to go from here. Maybe one of you dealt with this before.

Thanks,

bridrod

Correction: JS filter: https://bpa.st/PXCA

kthorngren

This FAQ provides options to help increase Datatables speed. Probably the place to start is to create a server based solution. Let Datatables fetch the data via ajax. This may help increase the load speed. If its still not enough then you will need to use Server Side Processing to allow for server side paging of the data.

Kevin

bridrod

I tried the client-side improvements, but haven't noticed a difference. So, I am trying the server-side now. Struggling with it a bit. Let's see where I can get to with it.

Thanks!