title: When is it time to switch to NoSQL?
body: <p>I am dealing with a large database that is collecting historical pricing data.  The schema is relatively simple and does not change.</p>
  
  <p>Something like:</p>
  
  <p>SKU (char), type(enum), price(double), datetime(datetime)</p>
  
  <p>The issue is that this table now has over 500,000,000 rows and is around 20gb and growing.  It is already getting a bit difficult to run queries.  One common query is to get all skus from a specific date range consisting of maybe 500,000 records.  Add any complexity like group by, and you can forget it.</p>
  
  <p>This db is mostly writes.  But we obviously need to crunch the data and run queries occasionally.  I understand that better index planning can help speed up the queries, but I am wondering if this is the type of data that would benefit from a noSQL solution like MongoDB?  Can I expect mysql (probably moving to MariaDB) to continue to work for us, even after it grows beyond 100-200 gb in size? Or should I explore alternatives before things get unweildly?</p>