有没有更好的方法来获得限制1的随机记录

Question

Is there a better way to get a random record with limit 1

I am using the below Query

$r = mysql_query("SELECT username FROM user ORDER BY RAND() LIMIT 1");

but this creates a terrible bottleneck to me (my system slows down very much almost it gets hanged). Is there a better option to do this.

Answer 1

I have tried this which has given me a better performance

$r = mysql_query("SELECT count(*) FROM user");
$d = mysql_fetch_row($r);
$rand = mt_rand(0,$d[0] - 1);

$r = mysql_query("SELECT username FROM user LIMIT $rand, 1");