title: MySQL: Better few tables with millions of rows or thousands of tables with hundrets of rows
body: <p>I'm building an web application and I want to make it scale from the start. I'm not very much into Database scalability and I'm facing this doubts: </p>
  
  <p>Should I use a handful of tables with millions of rows or shall I split stuff into hundreds of tables if not thousands of tables with expectedly hundreds of rows.</p>
  
  <p>I can go both routs but I don't know which one will scale better in the long run.</p>
  
  <p>I found some info on this tread, but it's not helping much: <a href="https://stackoverflow.com/questions/13765716/mysql-whats-better-for-speed-one-table-with-millions-of-rows-or-managing-multipl">MySQL Whats better for speed one table with millions of rows or managing multiple tables?</a></p>
  
  <p>Basically I need to know, it's better to scale a database vertically or horizontally?</p>