Use the Cache Control builder to set up caching for a database query.
- Place a Cache Control builder in a model.
- Configure the builder by selecting Action to Cache.
In most cases, the specific "Action to Cache" is the executeForCaching method on the sqlCallNameTransform LJO. This LJO is added to the WebApp by the SQL Call builder.
- Specify in the builder the length of time to retain information in the cache (Refresh Interval input) and the trigger to use to refresh the cache (Keys input).
Parent topic: Working with a database