2 ms·
I see, apologies. However, I'm reasonably certain we'd see poor performance with that query on MySQL 5.7, but I don't think it's got as good an optimiser as Po
by gtsteve 6y ago
I see, apologies.
However, I'm reasonably certain we'd see poor performance with that query on MySQL 5.7, but I don't think it's got as good an optimiser as Postgres for example.
- btilly 6y agoI can't say that MySQL doesn't perform poorly. But if so, then their optimizer is more broken than I though. Even SQLite figures this one out and does it right.