1. Home
  2. Forum
  3. Dashboard Platform
  4. Syncfusion Dashboard Server loads dashboard very slowly

Syncfusion Dashboard Server loads dashboard very slowly

Syncfusion Dashboard Server loads dashboard very slowly.

I have dashboard which I uploaded to SyncfusionDashboard Server to share Dashboards through a web interface.
Before I tested my dashboard via Syncfusion Dashboard Designer preview (localhost) speed was ok.
But when I uploaded it to Dashboard Server, my uploaded dashboard initialized (fetch data) for long time..
Sometimes it initializes, sometimes not (just blank widgets).

The problem of Syncfusion Dashboards is that they can not load data from Data Source dynamically by swap parameters.
So they load and cache the whole data slice and users just filters it on UI..

And looks like Dashboard Server uses some kind of proxy to fetch data for dashboard..

Can anybody explain me what should I do to improve dashboard loading speed?

5 Replies
AR Anandaraj Radhakrishnan Syncfusion Team December 21, 2017 12:49 PM UTC

Hi Ilya, 
                                                                                            
Thank you for contacting Syncfusion support. 

Our dashboard loads the data from data source dynamically.  Please provide the following details to understand your case better, 
  • Connection type details
  • How much records do have in your data source?
  • If you your using any file type or Web Data Connection, provide the details of Publishing Options which you were chose during publishing?
Note: For Publishing Options refer the screenshot. 
 

If you have the large amount of data in your data source, you can use the live query or data agent option in publishing dashboard. It required a target database server like SQL Server to move the data which improves your dashboard’s loading speed. Please refer the link for publishing dashboard into the server.  

Please let us know if you have any concerns. 

Regards, 
Anandaraj R

IB Ilya Bo January 3, 2018 09:20 PM UTC

Hi Anandaraj,

I use web datasource to fetch data from REST API.
I have a lot of data on the REST API side.

Can you please explain how to publish dashboard correctly to make it possible to use live queries by parameters? 
In particular, my REST API supports date range parameters.

In docs all about Database Server live queries but not about Web Datasource.
How to deal with Web Datasource?

Thanks!

AR Anandaraj Radhakrishnan Syncfusion Team January 4, 2018 01:17 PM UTC

 Hi Ilya, 
 
We have provided three publishing ways to publish our dashboard. File type data sources, Salesforce, Microsoft Azure and Web Data Source connections are published into the dashboard server by migrating data to the existing server like SQL, MySQL, Oracle, PostgreSQL. For all other direct server type connections like SQL, MySQL, Oracle, PostgreSQL, SSAS, etc.… dashboards are published with their own server connection itself (no data migration happens here).  
 
NOTE: File type data sources, Salesforce, Microsoft Azure and Web Data Source connections only has these publish options. 
 
  1. Extract to embedded database –Underlying/internal data source which loads and manipulates the data in designer will be automatically shipped while publishing. No efforts required from the user to configure this.
NOTE: Meanwhile when shipping the underlying/internal data source, performance might be slightly slow compared to other options.   
  1. Live Query - We need to move our data to any existing/target server like SQL, MySQL, Oracle.
  2. Data Agent - We need to move our data into the SQL server only. We will be able to update the data from data sources periodically. In this process we need to install our data agent tool.
 
We have attached the demo video on publish the web data source dashboard into the server. 
 
 
Please let us know if you have any concerns. 
 
Regards, 
Anandaraj R. 
 


IB Ilya Bo January 12, 2018 04:14 PM UTC

Hi Anandaraj,
That means there is no way for Web Data Source dashboards, only migrate data to the server like SQL, MySQL, Oracle, PostgreSQL?

VS Venkataprasad Subramani Syncfusion Team January 15, 2018 12:49 PM UTC

Hi Ilya Bo, 
  
As already mentioned in our previous update posted on December 21, 2017, we have provided three publishing ways to publish our dashboard for web data source connection type such as Extract to embedded database, Live Query and Data Agent.  
  
If you are using the Extract to embedded database option for publishing the data source then there is no need to migrate the data into another database server such as SQL , MySQL , PostgreSQL or oracle. The migration of data into a another server is only required for the other publishing options like Live query and Data agent. 
  
Please let us know if you have any concerns regarding this. 
  
Regards, 
Venkataprasad S. 



Loader.
Up arrow icon