/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

2 votes313 views2 answers
Change varchar length mysql
SQL
7 votes324 views2 answers
Mysql get year from date
SQL
0 vote295 views1 answer
Renommer table sql
SQL
0 vote314 views1 answer
EnvironmentError: mysql_config not found
SQL
0 vote322 views1 answer
Sintaxis SELECT sql
SQL
2 votes330 views5 answers
Eloquest how to select one specific column in database
SQL
0 vote372 views1 answer
Mysql convert charset
SQL
1 vote324 views1 answer
Mysql select all and rename one
SQL
1 vote300 views1 answer
GROUP BY clause; this is incompati
SQL
0 vote326 views1 answer
How to add timestamp column in mysql
SQL