3 ms·
In my experience, if you have a proper schema, even very complex, but thought-out, queries are instant on virtually any database size.
by amq 9y ago
In my experience, if you have a proper schema, even very complex, but thought-out, queries are instant on virtually any database size.
- z3t4 9y agoStuff 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.