title: Caching JSON objects on server side
body: <p>I have a server which contains the data to be served upon API requests from mobile clients. The data is kind of persistent and update frequency is very low (say once in a week). But the table design is pretty heavy which makes API requests to be served slowly</p>
  
  <p>The Web Service is implemented with Yii + Postgre SQL.</p>
  
  <ul>
  <li>Using memcached is a way to solve this problem? If yes, how can I manage, if the cached data becomes dirty?</li>
  <li>Any alternative solution for this? Postgre has any built-in mechanism like MEMORY in MySQL?</li>
  <li>How about redis? </li>
  </ul>