This property enables or disables the data cache. After configuring the Enable Database Access Caching property, you have to configure the Change Frequency Property for each table that you are interested in being cached.
The result set of each query to the table is stored in a memory cache, and while the cache does not expire, the cache is queried in each read operation and the database is not accessed.
|No ||Caching is disabled. This is the default value.|
|Yes ||Caching is enabled.
The property is at generator level.
The expiration of the cache is configured in the Time to Time TTL(mins) Property and Hardly ever TTL(mins) property.
After changing the value of the property, a rebuild all is needed. All the programs which navigate to any table which is affected by this property, will change its source code.
Platforms: Web(.Net, Java)
Time to Time TTL(mins) Property
Hardly ever TTL(mins) property
Cache storage size property
Change frequency property