GQI query : Get bookings data source

Solved301 viewsGet bookings GQI Data Source GQI queries
1
0 Comments

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

2 Answers

2
18.56K 0 Comments

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
You are viewing 1 out of 2 answers, click here to view all answers.