Cached Data Considerations

To avoid querying the database each time data is requested by a client, the ICONICS Databases Point Manager temporarily caches a Data Source's query results in memory. When a Data Source is requested by a client, the cache is checked. If there is no data, the query is executed and the result is cached before being returned to the client:

If a client requests the same Data Source, the ICONICS Databases Point Manager will return the data from the cache:

The use of the cache improves the performance of the application and reduces the load on the database. The following sections detail caching mechanisms, to better explain its impact on performance.