Solutions to Improve Efficiencies of Random Select in MySQL

Solution 1 - just Order By Rand() SELECT * FROM user ORDER BY rand() LIMIT 10 This solution is not recommended, because the more the data is, the slower it is. Solution 2 - Use JOIN method one by on...
2017/10/29   Memory, Renee   134