Wonder what life would've been like without the friendly old GROUP BY. I just fired
SELECT SUBSTRING_INDEX(...), A, COUNT(*) FROM Foo
WHERE Bar = Baz GROUP BY SUBSTRING_INDEX(...), A.
Now watching the server slog with more than ten million rows over which to do the substrings, grouping and aggregation.
Update: Took 16 minutes to turn the
(
Read more... )