Looking for a little help from the DBA and IT folks in the crowd. I’ve just ported the project I’m working on over to MS Sql Server. During one of my processes I make thousands of requests to the concept and the concept relation table (to get standard codes from non standard codes). These queries were under a second but not by much in some cases and added up to a significant delay that was not acceptable. I was able to write my own caching layer and seize the day, however, I’d like to think there’s something already out there that might be a little more tried and true.
Are there off the shelf caching tools that sit on top of MS Sql Server that others have used in the past with success? Bonus points for ease of install/configuration/maintenance and feeding. More bonus points for free (or it is already built into MS Sql Server somehow?).
Edit: My project is written in Java