How to optimize ORDER BY RANDOM()
Tom Witowsky (@devgummibeer) shared on Twitter a scaling issue with his service opendor.me, which helps any developer share and highlight their open source work. As the service grows, more and more data is stored in the database and needs to be browsed. One particularly slow query that he needed help optimizing is fetching random users, organizations, and repositories that are already part of the service.
Source: How to optimize ORDER BY RANDOM(), an article by Tobias Petry.