title: How should I use Redis as a cache for SQL Server?
body: <p>I have got some tabular data that due to unrelated issues is proving too slow to get out of SQL Server in realtime.  As we get more users this will only get worse so I am thinking of using Redis as a front-end cache to store users' tabular pageable data.  </p>
  
  <p>This data could become stale after about 10 minutes after which time I would like to get the record set again and put in in Redis.</p>
  
  <p>The app is an .NET MVC app.  I was thinking that when the user logs into the app this data gets pulled out of the database (takes around 10 seconds) and put into Redis ready to be consumed by the MVC client.  I would put an expiry on that data and then when it becomes stale it will get refetched from the SQL Server database.</p>
  
  <p>Does this all sound reasonable?  I'm a little bit scared that:</p>
  
  <ol>
  <li>The user could get to the page before the data is in Redis</li>
  <li>If Redis goes down or does not respond I need to ensure that the ViewModel can get filled direct from SQL SErver without Redis being there</li>
  </ol>