Json Data Load on Pivot Table Performance is Very Bad

Webix JS
1

Dear Sirs,

I am evaluating the trial version of Webix Pivot Grid to use in a somehow large application and the performance is very bad.

I loaded (JSON with 40 MB) 100.000 records with monthly values of 5.000 items that are being analyzed (each item has planned, budgeted and actual values during its life span that varies from 1 to 48 months).

The data loading process took about 30 seconds (Reading from SQL Server, creating JSON file and opening the Pivot Grid blank screen) which is quite reasonable.

When I configured the fields in the ‘Pivot Configuration’ modal to produce the screen as shown below, it took 19 minutes to renderize.

I am using Visual Studio 2013 with IIS Express on a Dell Notebook Core i7 with 8 GB Memory (Windows 8.1). I run the Grid with Internet Explorer.

What can I do to significantly improve the performance? – May it be a problem with the trial version?

Thanks for your help.

Marcio (Brazil)

2

The issue is not related to the trial version. ( trial version has not any functional limitations )

Most probably, performance degradation caused by a huge number of calculated parameters.

If you have some dataset which you can share, we can analyze the performance issue and probably improve the situation. The 19 minutes is really very, very huge time, it can be decreased for sure, but I think it still will be at 1-minute level, for such big amount of data.

3

Hello, first thank you for your attention.
I can provide the json file with the data we are using.
What better way to send this file to you? Email, FTP, Dropbox?

4

Email, or a dropbox link will be fine ( you can send this info directly to support@webix.com )

5

I have sent through email with JSon file attached and Dropbox link.