What is a Cache Miss?
Anytime a value is not found in a table variable for a specific set of criteria, it is considered a cache miss. All misses are stored in the cache however; the Category Miss Buffer Purge % can be set to purge a certain percentage of the misses. Consider the following mapped variable table:
| Variable | Criteria | |||
|---|---|---|---|---|
|
Territory Code |
ZIP Code |
City |
County |
State |
|
1 |
75080 |
Richardson |
Dallas |
Texas |
|
2 |
75081 |
Richardson |
Dallas |
Texas |
|
3 |
75082 |
Richardson |
Dallas |
Texas |
|
4 |
75083 |
Richardson |
Dallas |
Texas |
|
5 |
75085 |
Richardson |
Dallas |
Texas |
Then the following data request would be considered a miss and the default value for the mapped variable would be used:
ZIP Code: 75084
City: Richardson
County: Dallas
State: Texas
If this same request had not been made previously, then a call would be made to the database to retrieve the information. When a value is not found in the database for the request, the default value would be used and the information would be stored in the cache as a miss. A subsequent request with this same information would result in the information being found in the cache, and a call to the database would not be necessary (unless the miss had been purged from the database).
