On: We saved $50k/year with a Go microservice coded in a hackathon

[amq]

In my experience, if you have a proper schema, even very complex, but thought-out, queries are instant on virtually any database size.

[z3t4 → amq]

Stuff like the group builder in the article is hard to reason about as there are so many combinations. MySQL is bad at optimizing O(n2), no matter how you design the schema it will be slow. The solution, like they probably did in the article, is to break it down into separate more simple O(n) queries.