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 ?
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.
Hi Wale,
Could you share the DataMiner version you are using? Since version 10.4.2, a GQI count aggregation based on the ID column should be optimized to go to the DB, which should result in significantly faster load times. (RN38096)
Could you also share the DB configuration this agent or DMS is using? (Elasticsearch, OpenSearch or STaaS)
Hi Thomas,
This is good to know. The DMS in question is running 10.4 CU 7 with Elasticsearch.