title: What is a better way to store status updates in a database?
body: <p>I'm developing a web application that will enable users to post short status updates similar to Twitter. The only way I can think of storing these posts is to have a large "status_updates" table that stores EVERY user's status updates:</p>
  
  <pre><code>--------------------------------------
  | table: status_updates              |
  -------------------------------------|
  | id | user_who_posted | update_text |
  --------------------------------------
  </code></pre>
  
  <p>This method requires something like this SQL query to get each user's updates:</p>
  
  <pre><code>SELECT * FROM status_updates where user_who_posted="username"
  </code></pre>
  
  <p>and I think that wouldn't be very inefficient. Is there a better way of doing this?</p>