Database results caching can be used to minimize the amount of traffic between Proficy Portal and your database. Database results caching works by performing a specific SELECT or CALL statement once, and storing the data retrieved for a specified amount of time. Subsequent calls to the stored SELECT or CALL statement read the data stored in the cache, and do not retrieve new data from the database server.
Database results caching is useful if you connect to a remote data source whose data is not frequently updated. As the data is stored locally, requests via Proficy Portal will be returned faster than if the data had been polled directly from the database.
