/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

13 votes297 views2 answers
Sqlite rename table
SQL
-1 vote192 views1 answer
Mysql case when multiple conditions
SQL
0 vote199 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
0 vote257 views2 answers
Mysql cast to varchar
SQL
15 votes319 views4 answers
Mysql export database command line
SQL
0 vote193 views1 answer
Get number of table colums in sql query
SQL
5 votes262 views2 answers
Mysql where in array
SQL
0 vote231 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
0 vote202 views1 answer
Sql find leading space
SQL
1 vote208 views2 answers
Mysql update LAST_INSERT_ID()
SQL