Improve Speed for Flexmonster : 1million row

Hi flex monster Team !
 
We use your product, and we are very happy with. 
I just have a question about the speed : 
Can you provide me your one million row file ?
Because, i do not have so much rows, but more columns, and all-in we will have the same numbers of cells.
But your one million row speed more or less intantly. So i’m very curious about this file or the method you use to retrieve to the browser.
For information, here we use both compression (by compressor lib, and sending gzip content), but i try multiple combinaison, and this one was the better.
 
Thanks,
 
Gildas Brun
 

3 answers

Public
Dmytro Zvazhii Flexmonster May 8, 2018

Hello Gildas,
Thank you for your kind words. You did a great job optimizing your Flexmonster’s performance. Speaking of our one million row demo, our million row demo was specially designed to demonstrate how Flexmonster component can operate with such amount of data. The pivot rendering remains smooth during all the time. In this demo, Pivot component generates data by itself to avoid data transfer through the web. That is why it is so fast in loading the data. Still, you are welcome to try our 1 million row JSON which we use for the tests.
Please let us know if you have any additional questions.
Regards,
Dmytro.

Attachments:
data1000k.zip

Public
Gildas Brun May 8, 2018

Hi Dmytro,
Thanks fro your answer, i will test it asap.
Just for your information, and to put some figures, our file is 22 MB, after using Compressor (ocsv file), approx 140k lines and 50 columns.
On my laptop, with Opera, the full load takes ~30 seconds, including 3 sec of loading data from our server (flexmonster 2.5.2)
That’s why i was wondering about the loading into the component.
By the way, is it Json faster for loading data (not transferring) into your product ?
 
Thanks for your answer.
Gildas

Public
Dmytro Zvazhii Flexmonster May 8, 2018

Hello Glidas,
Thank you for your feedback. Could you please have a look at the following article: https://www.flexmonster.com/blog/sql-pivot-table-best-performance/? It describes some key ideas of getting a better performance. Speaking of JSON and OCSV, it is difficult to compare them since we start parsing OCSV file from the moment we got the first chunk. At the same time, the component starts parsing the JSON when it is one hundred percent loaded. Still, JSON is some kind of native format for the browser, therefore, it may have some benefits during the loading process. However, usually, we recommend our client to make all the necessary tests and then choosing the best approach which fits their data.
Please let us know if there is anything else we can help you with.
Regards,
Dmyrto

Please login or Register to Submit Answer