Flexmonster pivotgrid freeze navigator when load a large CSV file
I’m working with the pivotgrid, i pass a CSV file about 300Mb, with a 500.000 Rows aprox, but when i Load the CSV in the pivotgrid the navigator Freeze and make a Error.
How i do to load the CSV, i test GZip the content but the navigator gave me the same error.
Could you please provide us with the text of the error you get?
The component supports GZip.
I would recommend you checking our CSV Compressor. It is available for .NET, Java and PHP and its newest version can be downloaded together with the front-end component from http://www.flexmonster.com/download-page/?edition=advanced.
Also, I would recommend you reading the blog post OLAP vs CSV: What to Choose to Boost Your Pivot’s Performance.
I try the CSV Compressor, i convert the csv in ocsv file and pass it to the pivot grid but the navigator gave me an error and close all the pages with the same error.
The ocsv file is about 42Mb.
The error is:
IMG of Error
It looks like your file is too large to store in the browser’s memory. In this case, I can recommend you to prefilter your data and split it to smaller chunks.
But the description of the grid Says that support 100Mb of CSV data, i think that can do.
How i split in parts the ocsv data and how i pass it to the grid?
Thanks for your help.
Yes, you are right, the description says 100Mb of CSV but it doesn’t say the same about compressed data. I suggest using the server-side prefiltering tool. It will help you to reduce the amount of loading data.