What is SyncFusion doing when new table is added to a datasource

[Eric Kok]

In other words, how can we speed up this process? 

Eric 

[Anandaraj Radhakrishnan]

Hi Eric, 

Thanks for contacting Syncfusion support. 

When a new table is added as data source, Dashboard Designer uses two-different kind of process based on connection type which is explained below, 

• For Server connection types like SQL, MySQL, Oracle, PostgreSQL, Hive and Spark, designer directly queries the corresponding data source when we add a table.
• For File type, Web data source, Salesforce and Microsoft azure connection’s, data are migrating to an in-memory datastore. Also, we load only the limited records into the design view to speed up the process. So, initially designer loads only 100 records in data preview grid.

Based on your previous forum updates, we confirmed that your using MySQL from AWS. If so, please check the subscription speed of your AWS. Since we directly query from the database, speed depends on query execution time in corresponding database server. If you are using connection other than MySQL hosted in AWS, please let us know we will check and suggest you the possibility of increasing the speed. 

Please let us know if you have any concerns. 

Regards, 

Anandaraj R. 

[Eric Kok]

We use the MySQL-compatible Aurora version with instance type db.r3.large. We use the default settings from Amazon.

Please advise on how to increase that speed, as it takes 3-5 minutes before a table (with 2 records, 21 columns) has been added to a data source.

Eric

[Anandaraj Radhakrishnan]

Hi Eric, 

 

Thanks for the update. 

 

Based on our previous update we directly query from the database, speed depends on query execution time in corresponding database server. In general, query fetching process is based on our system RAM and internet access speed. Also, we have checked with this on Amazon web service and they have provided some solution to speed up the query process for MySQL-compatible database. 

Please find the reference link here https://aws.amazon.com/blogs/aws/amazon-aurora-update-parallel-read-ahead-faster-indexing-numa-awareness/                                                                                                                                                                                     

 

Regards, 

Anandaraj R.