We are trying to integrate data source from a large file csv, its crashing the browser. How can we implement the data table server side approach for csv files.

Import the content of the csv into a database like mysql or into a temporary sqlite db stored on the disk. Then afterwards you can query this source via mysql and do paging via limit and offset.

Would be interesting to know though if koolreport has an option to "query" a dataStore that has all its data in an array structure.

Hi Tony,

Thanks for the update. We have concern since the CSV is more that 15 MB. Its crashing the browser memory while taking in to koolreport.

Hi Jathin,

I recommend you upload the file in a koolreport independent process then quickly dump the content to a sqlite database. Once done you can start with the koolreport part using your temporary db as a source, then use service side processing (paging) to put as less load to the browser as possible.