Hacker News Reader

"Not having had in-house prior experience with such data volumes on MySQL ... At this point, we're considering the following 3 options:"

4. Hire or contract a consultant/expert. Part of their assignment could be to teach you.

View on HN

Hey, thanks :) We are actually considering this, but it skipped my mind while making the post.

This is probably the right answer. Look at it from a cost-benefit POV - how much money will getting the right answers now save you in the long run?

good call. there's a lot of free resources / open source projects with tools for optimization and locating pain points/bottle necks. i'd check those out first. see the types of queries that are slowing you down. then optimize.

Reply on news.ycombinator.com