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 5 days ago
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)
Wale Oguntoyinbo [SLC] [DevOps Enabler] Posted new comment 5 days ago
Hi Thomas,
This is good to know. The DMS in question is running 10.4 CU 7 with Elasticsearch.