A customer's database, which is used as a source for a lookup table, is modified on a regular basis causing the data to become invalid within five minutes. The databasecontains5,000,000 rows and is indexed on the field to be joined on and optimized for reading. How should the caching settings be configured for this lookup table?
A. Disable caching.
B. Enable caching with a setting of "20" in the "Number of results to cache" field.
C. Enable caching with a setting of "20" in the "Number of results to cache" field and set an invalidation schedule for every five minutes.
D. Enable Caching with a setting of "20" in the "Number of results to cache" field, set an invalidation schedule for every five minutes, and enable prefetch.
A customer's database, which is used as a source for a lookup table, is modified on a regular basis causing the data to
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
A customer's database, which is used as a source for a lookup table, is modified on a regular basis causing the data to
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!