asked on December 16, 2015
Can you please let us know which one gives better performance between CSV and JSON?
Is JSON data give better performance than CSV (may not be true), just like to hear from you.
⋅ December 16, 2015
In general, CSV gives better performance comparing to JSON. There are two aspects that should be taken into consideration: performance of loading data and performance of parsing data. Performance of loading data will be better in CSV because the same data composed in form of CSV will result in less Kilobyte comparing to JSON. Performance of parsing data will be better in JSON since this format is more native for JS and it needs less operations with strings during the parsing phase comparing to CSV.
Please note that there are different limits for Professional edition for CSV and JSON. In Professional edition the limitation for CSV is 2MB and for JSON - 2K records. If you decide to upgrade to other editions, you can find the information on limitations on our website https://www.flexmonster.com/pivot-table-editions-and-pricing/. Still, Site edition has some limits CSV - up to 4MB, JSON - 4K records. Advanced and Premium editions have no limits of this kind.
