GQI query : Get bookings data source

15 viewsGet bookings GQI Data Source GQI queries
0
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 ?


Miguel Obregon [SLC] [DevOps Catalyst] Answered question 3 hours ago

1 Answer

0
16.53K 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.

Miguel Obregon [SLC] [DevOps Catalyst] Answered question 3 hours ago