asked on September 14, 2021
We load 240.000 rows from SQL Server.
After the query completed on SQL Server side, the browser needs around 6 minutes to analyse 240.000 rows with 25 columns - Int, Money and nvarchar(255) values of compressed around 5 MB.
In my opinion this is much to much time - where could be the problem ? Client PC has 8 GB RAM.
⋅ September 15, 2021
Hello,
Thank you for contacting us.
Please note that 5 MB is the size of the archived data transferred over the network. After unpacking, the data set takes more than 280 MB as demonstrated in the attached screenshot.
We recommend using a direct connection to JSON/CSV when the data set size does not exceed 100-150 MB.
For larger data sets, we recommend using Flexmonster Data Server, which is a middle layer between Flexmonster and your database. It is responsible for fetching data from a data source, processing, and aggregating it. Then the data is passed to Flexmonster Pivot in a ready-to-show format. The Data Server significantly reduces the time of data loading and enables analyzing large datasets.
Moreover, the Data Server supports connection to a Microsoft SQL Server database by default.
Please let us know if it helps.
Feel free to reach out if any additional questions arise.
Kind regards,
Illia
⋅ September 17, 2021
Hello Illia,
thank you, we will try this.
Gerd
