Slow load csv files

Question

Your demo is very slow at loading csv files. I know its a big accomplishment just to load them but working with files in my opinion needs to be faster to be useful to the end user because they would leave the page when bored. With that said how should I save the data for it to load faster? Your control is awesome. Even when I upload files and read them using the XLSX.js component for the datagrid it's slow but if I read data from a database it's blazing fast. So do you recommend that I save my csv file's in a db and create a JSON object to load? Anything special about how to structure? Will it create the columns automatically if I don't identify them?

Thanks

Sangeetha Priya Murugan · Accepted Answer

Hi William, Query #1: Loading CSV files in demo siteFor
 demonstration purposes, we published our web service open/save action 
and mentioned it in our demo site.You can use this demo URL on your end 
as well, or you can use a local service for open and save actions. And 
we have published our API services in the GitHub location; for more 
details, please refer to the below links.Service sample Location: https://github.com/SyncfusionExamples/EJ2-Spreadsheet-WebServices/https://ej2.syncfusion.com/react/documentation/spreadsheet/open-save/You can use the above web service for open/save actions to resolve performance issues on your end. To create the local web service, please refer to the below link. https://www.syncfusion.com/kb/13200/how-to-remove-trial-version-tab-created-in-spreadsheetQuery #2: To save/retrieve the spreadsheet as JSON in data base Your requirement can be achieved in our spreadsheet by using the openFromJson and saveAsJson methods. We have already demonstrated this in our KB documentation itself. You can refer to the below link.Load and save Spreadsheet as Byte array in Data Base:https://www.syncfusion.com/kb/11971/how-to-save-and-retrieve-the-spreadsheet-data-as-a-byte-array-in-the-databaseLoad and save spreadsheet as JSON in Data base:https://www.syncfusion.com/kb/11956/how-to-save-and-retrieve-the-spreadsheet-data-as-json-in-databaseLoad and save spreadsheet cell data in SQL Table:https://www.syncfusion.com/kb/12575/how-to-load-and-save-a-sql-table-in-spreadsheet-using-cellsave-eventTo save/open the excel file in server, please refer to the below link.https://www.syncfusion.com/kb/11970/how-to-open-and-save-an-excel-file-to-server-in-the-spreadsheetAPI Links:https://ej2.syncfusion.com/documentation/api/spreadsheet/#saveasjsonhttps://ej2.syncfusion.com/documentation/api/spreadsheet/#openfromjsonPlease get back to us, if you need any further assistance with this.

William Morgenweck · Answer

This is fantastic-  Thank you

Sangeetha Priya Murugan · Answer

You're welcome, William. Please feel free to contact us if you need any other assistance.

NOTE: If that post is helpful, please consider accepting it as the solution so that other members can locate it more quickly.