Which data source method has a better performance edge CSV or JSON

Answered
Umar Siddiqui asked on September 18, 2018

By performance I mean

  1. Data load time
  2. Memory consumption

And also if any other data source which will give me better performance then CSV or JSON as well.
Please note CSV or JSON files are being load from server

1 answer

Public
Dmytro Zvazhii Dmytro Zvazhii Flexmonster September 18, 2018

Hello Umar,
Thank you for writing. Please find our answers below:

  1. If you need to increase the data loading speed please try our Flexmonster Compressor. You can compress CSV and JSON and stream the result directly into the component: https://www.flexmonster.com/doc/connecting-to-relational-database/. The compressed result has the OCSV data type.
  2. Speaking of memory consumption, there is no difference comparing those two data sources. Both of them are loaded into the browser's memory. The component will create the same structure from the equal JSON, CSV and OCSV files.

Please let us know if you have any other question.
Regards,
Dmytro

Please login or Register to Submit Answer