Results 1 to 10 of 10
Thread: Is RAND() function really bad?
Feb 12, 2010, 08:52 #1
- Join Date
- Oct 2008
- Virtual World is my location
- 3 Post(s)
- 0 Thread(s)
Is RAND() function really bad?
I used RAND() function and don't seem to notice much difference. My table size is around 10000 records and on my local system it takes around 5 seconds when I run RAND() LIMIT 50
Secondly using the RAND function many times I get either the top most random records or lower side.
Is there any better way I could get 50 random records spread across the entire table?