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   3429
1/1