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