Is this fastest way to get random records in mysql?

Asked Jun 16 '15 at 15:00

Active Jun 16 '15 at 15:00

Viewed 25 times

NOTE : Yes! there are number of related questions to this.But I have unique approach which is not mentioned in any other post and I want to know if it is fast.

So all other questions have accepted answer as below

SELECT * FROM catalogue order by RAND() LIMIT 5

But I heard it is too slow for large table.So I want to know if below approach is faster than above code.

//I know my row count.500k
<?php
$rand = rand(1,499990)
$limit = "$rand , ",$rand+10;

and my query wil be

SELECT * FROM catalogue  LIMIT $limit

where $limit will be like 1,10 , 450,460 etc...

asked Jun 16 '15 at 15:00

Vishnu

2,372
6
36
58

1

Your code will work to extract random number of records. – Goikiu Jun 16 '15 at 15:04
You could test with microtime() : http://php.net/manual/en/function.microtime.php – Clyff Jun 16 '15 at 15:08
http://stackoverflow.com/questions/1244555/how-can-i-optimize-mysqls-order-by-rand-function – castis Jun 16 '15 at 15:09

Is this fastest way to get random records in mysql?

0 Answers0