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