Hacker News new | ask | show | jobs
by bitL 4378 days ago
If you optimize for latency relational databases won't cut it.
2 comments

I'm the author of the article. At Monetate, we've chosen our data warehouses to maximize throughput, rather than minimize latency. That's where something like Redshift really shines, it's great a large bulk ingests and running large queries relatively quickly, but awful at running lots of small queries quickly.

On our busiest day last year, we ingested over a quarter billion page views across all of our clients' websites. I'm sure someone has made MySQL scale to that volume, but for us Redshift has been working great for a relatively low price point.

Thank you for sharing your experience! It's always inspiring to read well-written articles as is yours!
This might be the most inaccurate statement on the internet.
OK, I should have written "if you optimize for read-access latency". Better?