Re:SQL Databases Are An Overapplied Solution (And What To Us...
by dangrossman on Wednesday February 17, 2010 @08:47PM
(#1133196)
Meh, I record a couple million page views to a MySQL database (as a new row for every page view) every day, for 6 years. Works fine. I don't expect a million new users to show up any time soon.
Re:SQL Databases Are An Overapplied Solution (And What To Us...
by peterwwillis on Friday February 19, 2010 @12:22PM
(#1137379)
six billion five hundred seventy million rows?
Re:SQL Databases Are An Overapplied Solution (And What To Us...
by dangrossman on Friday February 19, 2010 @04:15PM
(#1137976)
Yes, I do actually have billions of rows. See http://www.w3counter.com
If you're collapsing the metrics that you're storing IN SQL there is something really wrong going on.
Logs are OK to store in SQL, assuming you're scraping your logs properly and are logging the proper things. Logging every clickthrough in a relational database is somewhat insane. Logging 10 minutes worth of aggregate clickthroughs is perfectly fine. If you think logs should be a ring buffer I challenge you to tell that to any admin of a system that is subject to laws governing the length of time you must store logs (which is pretty much all e-commerce?).