Performance troubleshooting of the queries on a dashboard.
I am trying to optimize my dashboard that runs too slow.
I have 6 queries on my dashboard.Each of them run up to 10 seconds when I execute them alone as a single query
on my dashboard or in the MC.
When I run all of them together it runs a full minute and even a bit more.
--one node cluster
--no other queries running on the db at the time when I run the queries on the dashboard.
--I have also created a dedicated resource pool for the dashboard with resource configuration as explained at
--I have changed "execution parallelism" to AUTO after seeing that putting "1" is not helping.
Attached is my resource pool configuration.
what could be the problem? it seems that the db is not running any of the queries in parallel and very very slow when