Improving Dashboard (Classic) Performance

564
2
10-21-2021 02:47 AM
MuhammadNaufalIhsan
New Contributor III

Hello guys,

I am currently working on a project using Dashboard Classic in Enterprise 10.9. The dashboard will be using referenced data from PostgreSQL version 12.4.

The data will be based on 3 kinds of data:
1. A polygon, with around ~91000 rows. I've already set the visibility scale to prevent all of the data to be shown at the same time.

2. A table, with around ~70000 rows monthly (with 2 years retention, so ~1.7 million rows), which will be used for diagrams. We've tried to limit the maximum categories and not use any grouped values to prevent on the fly calculation. The table and polygon will be connected through filter widgets.

3. A query layer (joining the aforementioned polygon and table) with a result of ~70000 rows. We've tried our best to only use this data when needed. Since the query layer tends to have poor performance.

Is there any other way to improve the dashboard performance? Whether from dashboard configuration level, database setting level, or even hardware level.

Best regards,

Naufal

0 Kudos
2 Replies
DavidPike
MVP Frequent Contributor

If you can do any spatial or attribute aggregations at the database level, and serve them as views/query layers to power any indicators/charts etc. I'd recommend it. 

0 Kudos
MuhammadNaufalIhsan
New Contributor III

Hi David,

We are currently using "feature" instead of "statistic" to prevent any attribute aggregations in the dashboard level. Does it work the same?

screenshot1.JPGscreenshot2.JPG

Best regards,

Naufal

0 Kudos