Dojo,
I'm setting up a report to give me the total number of bookings. On average it takes about 3 mins before the dashboard is populated with data. How can I make this query more performant ? as it looks like the average response time will continue to grow as more bookings enter the system. Where is the bottle neck if there is one ?
Thomas Ghysbrecht [SLC] [DevOps Enabler] Answered question 16th January 2025
Hi Wale,
Normally, for this kind of use cases, we proceed with creating an ad-hoc data source that could perform this aggregation in a more efficient way.
Another option is to use the Data Aggregator to execute this query and store the aggregated value in a CSV file. Then you can use a GQI query to read this value and display it in a dashboard.
Hope it helps.
Wale Oguntoyinbo [SLC] [DevOps Advocate] Selected answer as best 16th January 2025