I currently have a web application that caches a large amount of data (several hundred thousand records) in memory for quick retrieval, and then in SQL Server as a persistent cache. Basically, the information consists of address geocodes, where the geocode is retrieved through a remote web service, which takes time, if necessary, to call continuously, rather than caching.
Would using RavenDB (or other suggestions) be the best way to cache this information in persistent storage in terms of speed and memory? Currently, the application is hosted on a server that SQL Server sucks up most of the memory, so I would like to get an easier solution.
source share