Loading Dashboard is very very slow!

Stimulsoft Dashboards.JS discussion
Post Reply
Wadii
Posts: 8
Joined: Mon Nov 20, 2023 4:10 pm

Loading Dashboard is very very slow!

Post by Wadii »

Hello,

When create Dashborad with data from sql server DB, the loading is very very slow.
Here is my use case in detail :
- I referenced a table with 13615 lines of data
- I added just one Chart in the Dashboard with one column of Value and one column fo Arguments
- I added one variable
Loading Dashboard.png
Loading Dashboard.png (72.01 KiB) Viewed 4648 times
=> The result in the Viewer :
- 20 seconds to load variables panel!
- 1 minute and 6 secondsin total to load the Dashboard with only one chart!

Is this normal? Can you help me, please?

PS : Version: 2023.4.2
Lech Kulikowski
Posts: 6247
Joined: Tue Mar 20, 2018 5:34 am

Re: Loading Dashboard is very very slow!

Post by Lech Kulikowski »

Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.
Wadii
Posts: 8
Joined: Mon Nov 20, 2023 4:10 pm

Re: Loading Dashboard is very very slow!

Post by Wadii »

Hello,

I can't send you a sample because you need to have an SQL server database but it's very simple to reproduce, you just have to :
- create an SQL server database and create a table with 15000/20000 rows of data,
- add a graph, put one column of this table on the values ​​and another on the arguments,
- add a variables and filter on one of these 2 columns

Thank you.
Lech Kulikowski
Posts: 6247
Joined: Tue Mar 20, 2018 5:34 am

Re: Loading Dashboard is very very slow!

Post by Lech Kulikowski »

Hello,

Please add your variable in your query and filter data count for showing dashboard.

Thank you.
Post Reply