TL; DR version: for caching many small database tables that rarely change in my WCF.NET4 service. Which technology will be easiest to implement, easiest to maintain and best to implement, and why?
Long version: I am starting to work on a caching strategy for a new project. It used to be simple because there were fewer pre-packaged options (Enterprise Library for beginners), but now that access to the .NET 4 platform and AppFabric are available, I have to complicate the solution. Basically, I want to cache many small (<100 rows with 2-4 columns) database tables that rarely change, and my WCF service pulls it out of the cache, rather than retrieving it from the database every time. I started reading documentation, watching videos and downloading training materials, but experience is the best teacher and it was difficult for me to find comparisons between the two.
Any advice would be greatly appreciated! Thank!
source
share