title: How many rows are 'too many' for a MySQL table?
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/1926079/how-many-rows-in-a-database-are-too-many">How many rows in a database are TOO MANY?</a>  </p>
  </blockquote>
  
  
  
  <p>I am building the database scheme for an application that will have users, and each user will have many rows in relation tables such as 'favorites'.
  Each user could have thousands of favorites, and there could be thousands of registered users (over time).</p>
  
  <p>Given that users are never deleted, because that would either leave other entities orphaned, or have them deleted too (which isn't desired), and therefore these tables will keep growing forever, I was wondering if the resulting tables could be too big (eg: 1kk rows), and I should worry about this and do something like mark old and inactive users as deleted and remove the relations that only affect them (such as the favorites and other preferences).</p>
  
  <p>Is this the way to go? Or can mysql easily handle 1kk rows in a table? Is there a known limit? Or is it fully hardware-dependant?</p>