How to import large file of csv of size 2 GB plus in DataTables

Chethi007

I have a very large file of sizes 2GB plus and want to display in HTML table with search options.

I'm not sure how to use the server side reading of the large file and display in an HTML table. Gone through the demos of server-side data tables of 5000000 entries, but didn't get any luck on how to implement this in PHP.

Can somebody explain with some examples of how can I achieve this requirement?

Thanks, I advance

colin

Hi @Chethi007 ,

serverSide expects the data to be in a database. The client could request data in any order, with any filtering, so it wouldn't be practical to read directly from a file. I'd suggest importing into a DB then getting the PHP scripts reading from there.

Cheers,

Colin