Hi Dojo,
In dashboards we can create or own GQI Queries, and here will be multiple ways to get a same end result. But I'm sure that one way will be more performant than another.
Is there currently any way where we can measure the performance of such a GQI Query?
Thanks!
Hi Stacey,
It's never an easy answer when it comes to performance so let me cut some corners and point you to the 'Network' tab of the 'Developer tools' (F12).
There you'll see that each GQI query actually opens a session when executing. This session starts with an 'OpenQuerySession' request, followed by one or more 'GetNextQuerySessionPage' requests (after all pages are received we also have the 'CloseQuerySession').
The 'OpenQuerySession' contains information about the columns and a session ID while the 'GetNextQuerySession' contains the first page of data. After each request you'll see the time it took to perform that request.
Typically there are 2 cases:
- The time it takes to get the first page which is then used to already show something on the screen.
- The time it takes to get all pages (required for certain visualization such as node-edge, timeline, etc.).
What you should use depends on your use case.