On the application I’m currently working on we load reference data from an Oracle database into memory based on configurations provided by the user.
There are multiple configurations and then multiple ways that those configurations can be priced so we have two nested for loops in which we load data and then perform calculations on it.
When profiling the application we realised that some of the database calls being made with the same parameters and were therefore loading back the same reference data that we’d already loaded.
The most obvious way to solve this problem would be to move the code out of the loop and make less calls to the database that way but logically the domain is expressed more clearly when it’s inside the loop.
Alex therefore came up with an alternative approach where we wrap the database calling code in a caching decorator.
The caching decorator is a request scoped object so we’re only caching those results for a short amount of time which means that we don’t have to worry about cache invalidation because it’s thrown away when the request has been processed.
I’ve previously seen this problem solving by using a Hibernate second level cache which would cache results across requests.
In our application there are more likely to be calls to the database with the same parameters within the same request rather than across requests.
The load on the system is likely to come from complex requests where many prices needed to be calculated rather than from a huge frequency of requests
If that changes then we always have the option of caching at both levels but at the moment our current approach seems to work pretty well.