Im using GQI as data source to display the values in table, it takes some time to load the data in to the table and while loading the table looks empty. Also i am using Trigger to fetch data from DM every 30secs. Once the trigger is processed it takes 10secs to reflect the data into the table.
Do we have any workaround for this behaviour?
Hi Baranisudha,
For this case the best approach is to analyze first the data sources and operations available in your GQI query:
- Are you querying large tables?
- Are you using join operators? Joins are expensive operations and could affect the performance of your query,
- Are you querying historic data (e.g. trend data)?
For example, you could debug (by adding/removing data sources or operations) what specific part of your query is taking more time.
In case it is not possible to optimize the query with the default data sources/operations, then the next step is to use:
- Ad-hoc data sources: For example, using the GQIDMS class you could access data available in your DMS. In that way you could query data in a more efficient way
- Custom operators: Are you performing multiple operations in your query? You could create a custom operator that can combine all these multiple operations in a single operation. You could also optimize your custom operator.
Hope it helps.
Hi Baranisudha,
Is your staging environment a mirror of your production environment?
Normally staging environments have less elements (data) to be queried compared to a production environment. This could explain the behavior that you describe.
The best option here is to check the performance of the queries on your production environment.
I can see the same page is fast in staging environment.