/SQL/Mysql order by rand limit 1 really slow

Mysql order by rand limit 1 really slow

function get_random_row($mytable,$conn){
	$table_max_id = $conn->query("SELECT id FROM $mytable ORDER BY id DESC LIMIT 0, 1")[0]["id"];
	$rand_id=rand(1,$table_max_id);
	$random_result = $conn->query("select * from $mytable where id = $rand_id");
  	
	#note: if you are missing some id's, we can call again until we get hit
  	if(!$random_result){
    	return get_random_row($mytable,$conn);
    }
  
  	return $random_result;
}

Similar codes

25 votes140 views4 answers
Import mysql dump command line
SQL
0 vote142 views1 answer
Oracle chain step succeeded
SQL
0 vote136 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
0 vote157 views1 answer
Primary key start from number
SQL
0 vote119 views1 answer
Output table plsql
SQL
0 vote138 views1 answer
Select lowest values sql
SQL
7 votes133 views1 answer
Oracle pagination query offset
SQL
5 votes86 views1 answer
Mongodb vs
SQL
1 vote116 views1 answer
Can not connect to mysql server
SQL
8 votes131 views1 answer
Oracle create datafile
SQL