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?




Bookmarks