Hacker News new | ask | show | jobs
by XCSme 485 days ago
> our site(s) get heavy traffic everyday, in millions daily

Yeah, it's hard to run aggregate queries on MySQL once you are talking about hundreds of millions of rows, or billions. Even though, if the server has modern CPU, enough RAM to store the entire DB and NVMe storage, it's still okish with the right indexes and if the queries are optimized.

Thanks for sharing!