Caching Custome tables

Technote (FAQ)


Question

How to cache custome tables in Sterling Fullfillment suite?

Answer

Steps to make custom tables cacheable:

1) Identify the custom tables which can be grouped as configuration tables.
2) In file Extensions.xml, select those entities already identified from step 1) and add attributes Cacheable="true" EntityType="CONFIGURATION" for <Entity/> element. for example:
<DBSchema>
<Entities>
<Entity Cacheable="true" EntityType="CONFIGURATION" ApiNeeded="Y" AuditRequired="N" Description="" HasHistory="False" Prefix="WSI" TableName="WSM_TRANSIT_TIME" XMLName="TransitTime" >
</Entity>
</Entities>
</DBSchema>

Run dbverify.cmd tool to synchronized entity xml's and database. Run commands to re-build resources.jar and entities.jar
3) Navigate to customer_override.properties file and add entries for tables already defined as "cacheable" using step 2) as
(a) yfs.yfs.dbcache.classes
eg: yfs.yfs.dbclassCache.WSM_TRANSIT_TIMEclass=com.yantra.shared.dbclasses.WSM_TRANSIT_TIMEDBCacheHome
(b) yfs.yfs.dbcache.com.yantra.yfs.dbclasses.tablename.DBCacheHome=limit.rows
eg: yfs.yfs.dbcache.com.yantra.yfs.dbclasses.YFS_CustomerDBCacheHome=limit.rows=225000,
(c) Enable caching for custom table
yfs.yfs.dbcache.com.yantra.yfs.dbclasses.YFS_CustomerDBCacheHome.enabled=true
4) Re-start the server is necessary for changes to come into effect.

Steps to cross verify whether Cache is enabled or not:
Open up System Management Console to check if the above tables objects are under cached list of tables, as System management console --> Application Hosts --> Click on machine number --> Click on machine number under "Average Response Time for Application Servers in Group" --> under Cache info click on "Table level cache"


Rate this page:

(0 users)Average rating

Document information


More support for:

Sterling Selling and Fulfillment Suite
Data management - Data tracking

Software version:

All

Operating system(s):

All

Software edition:

All Editions

Reference #:

1599838

Modified date:

2012-12-20

Translate my page

Machine Translation

Content navigation