4 ms·
If they went to this much trouble it's presumably because selecting a random row is an actually slow operation for their database (and this is a pure gimmick fe
by stefan_ 3y ago
If they went to this much trouble it's presumably because selecting a random row is an actually slow operation for their database (and this is a pure gimmick feature so the weighting not being equal is irrelevant). MariaDB suggests that "ORDER BY RAND() LIMIT 1" involves a full table scan..
- WesolyKubeczek 3y agoWorse yet, they have had to struggle with MySQL’s idiosyncrasies since at least 3.22. There will be a lot of leftovers from those grim times that used to be “real clever hacks” back in the day.