| Performing Query Analysis | ||
|---|---|---|
 | Querying Efficiently |  |
| NetworkedPlanet | TMCore Engine API Guide |
| Performing Query Analysis | ||
|---|---|---|
| | Querying Efficiently | |
As the TMCore query language is simply SQL, it is possible to perform query analyses using standard tools such as the Query Analyzer that is part of the SQL Server toolset. Such tools can help indicate performance bottle-necks in a query. By default, the TMCore installation does not index any of the public views that can be used in your queries, so to boost query performance, you have two options:
Add indexes to the TMCore public views as indicated by your query analysis.
We do not recommend that you simply add indexes to all public views without first analyzing the most common and most time-consuming queries used by your system as over-use of indexes can impact database performance in other areas.
Create additional customised views using the TMCore public views as a source.
We do not recommend using the undocumented tables as a source for your customised views as these may change from one release of TMCore to another.
To aid analysis, you may want to log queries as they are executed by your application. These are logged as DEBUG messages in the log category networkedplanet.tmcore.system. Please refer to Chapter 14, Logging for more details.
| |  | |
| Limiting Data Read In A Results Row |  | Use The ApplicationOntology Cache Object |