Tuesday, March 17, 2015

Invalidating Cache: Data Cache Invalidation

Since Data Cache invalidation is self managed, We should not need to understand the underlying structure, but you may be curious about how Data Cache manages invalidations, or require additional information about this for your site tuning.


Data Cache invalidation IDs format in CACHEIVL

The Data cache dependency IDs are based upon which table is being cached, and what type of operation is performed to create this data. CACHEIVL entries are created by database triggers, and some Commerce processes, like Marketing or Solr. By default, CACHEIVL rows are created with a DATAID column value in this format:

WCx+TableName+colName1+colName2:%:colVal1:%:colVal2

Where x represents the type of operation that was performed, and the colName/colValue information is the unique index information about the record that was updated, so that the data cache can target the cache invalidation.  An example DATAID column value could be WCT+CATENTRY+CATENTRY_ID:%:10501, which would signify that the CATENTRY table row with CATENTRY_ID 10501 was updated, but we are not sure what operation took place.  The other operation symbols that can be used here are 'D' for deletes, or 'N' for a non-delete operation.

No comments:

Post a Comment