How to restrict some tables from getting cached.

Answer

Table caching is enabled by default for tables like YFS_ITEM, however depending upon the business process sometimes caching can hamper system performance.

There may be requirements to disable caching for such tables, below are the required steps that will restrict a particular table from getting cached.

This example is for table YFS_ITEM, the same can be applied to other tables.

#disabling cache

We can restrict a table from getting cached by using a property set in customer_overrides.properties file.

For example if we have to prevent caching of YFS_ITEM table, we can use following property.

yfs.yfs.dbcache.com.yantra.shared.dbclasses.YFS_ItemDBCacheHome=limit.rows=10000 0,enabled=false

Set this value in customer_overrides.properties file and restart your server, this will restrict yfs_item from getting cached.

The same value can be written as below:

yfs.yfs.dbcache.com.yantra.shared.dbclasses.YFS_ItemDBCacheHome=limit.rows=10000 0

yfs.yfs.dbcache.com.yantra.shared.dbclasses.YFS_ItemDBCacheHome.enabled=false<br />


Method (2)

Set following property in customer_overrides.properties file

dbclassCache.YFS_ITEM.enabled=false

This will also disable caching for the concerned table.


Note:

When you are disabling cache for an entity, you should also disable cache for its related entities. You can find the related entities from ERD.