title: Out of Process in memory database table that supports queries for high speed caching
body: <p>I have a SQL table that is accessed continually but changes very rarely.</p>
  
  <p>The Table is partitioned by UserID and each user has many records in the table.</p>
  
  <p>I want to save database resources and move this table closer to the application in some kind of memory cache.</p>
  
  <p>In process caching is too memory intensive so it needs to be external to the application. </p>
  
  <p>Key Value stores like Redis are proving inefficient due to the overhead of serializing and deserializing the table to and from Redis.</p>
  
  <p>I am looking for something that can store this table (or partitions of data) in memory, but let me query only the information I need without serializing and deserializing large blocks of data for each read.</p>
  
  <p>Is there anything that would provide Out of Process in memory database table that supports queries for high speed caching?</p>
  
  <p>Searching has shown that Apache Ignite might be a possible option, but I am looking for more informed suggestions.</p>