title: How to store big lists in memcached?
body: <p>I have a multi-tenant site that stores people's information across multiple MySQL tables. I can pull from different tables when I need different information about a list people.</p>
  
  <p>I've just started out using Memcached and I rather like it. I'd like to use it to speed up this process of filtering through the lists of people.</p>
  
  <p>My question is how would I effectively store people's information in memcached so when queries are processed, whether simple or complex, I don't have to load everything from the MySQL database each time? When I say complex, I will be querying multiple MySQL tables to find the people list I need.</p>
  
  <p>Some thoughts I had:</p>
  
  <ol>
  <li><p>Store ALL people's information (including info from linked MySQL tables) in memcached. Then when I need a specific group of people or need to generate a complex report, I filter through the array of people from memcached rather than query MySQL... The thing is, there could be thousands of people with 100's of rows of information each and I'm not sure if memcached can  handle that amount of data.</p></li>
  <li><p>Store people each time a new report or view is created. It will save it so if that same report is generated, it will pull from memcached.</p></li>
  </ol>
  
  <p>Any insight you can give would be much appreciated.</p>