Dashboard performance problem
Hi guys,
I have a view that once built has 112k rows. It is built from 7 datasets.
Am I right in thinking once the view is built then it doesn't need to go back to the datasets and perform joins etc?
I am seeing some very poor performance on the dashboard built from this view but the number of rows is quite low.
The widgets I am using are all period over period widgets.
Would you suggest anything obvious to check?
Thanks
Answers
-
Hi @Jones01, one suggestion is get your dataset, which powers your dashboard, to only have the relevant data for those views (as opposed to fetching all the possible records from those 7 inputs datasets). This can be done on the ETL v2, where you can filter records or remove columns, so that the processing time is reduced.
4 -
One another note, I made an idea suggestion around having the ability to pinpoint areas around dashboard performance: https://dojo.domo.com/main/discussion/53832/dashboard-performance-report. Please upvote if you agree
9 -
@Jones01 - I believe that dataset views are also not materialized datasets. Meaning that for each card on your dashboard, Domo is first performing the joins and then rendering the visual. If you are noticing performance issues, I might suggest joining the data in an ETL or SQL dataflow first. Alternatively, you could reach out to your Domo CSM to see if they can materialize the view for your instance to improve performance.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0 -
@ST_-Superman-_ Thank you. I had been under the impression they were.
I have also read about Adrenaline DataFlows. I thought what we had, used what ever Adrenaline is 🤣
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 299 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 55 App Studio
- 40 Variables
- 682 Automate
- 175 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive