/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

0 vote251 views1 answer
Dump only data
SQL
0 vote256 views1 answer
Postgresql stored procedure update table values
SQL
1 vote239 views1 answer
Mysql month name extract
SQL
1 vote233 views1 answer
Alter add syntax
SQL
8 votes211 views3 answers
Duplicate entry
SQL
1 vote241 views1 answer
List all triggers in SQL Server
SQL
1 vote262 views1 answer
Psql view enum values
SQL
0 vote238 views1 answer
Create sql table from script inline primary key constraint
SQL
0 vote235 views1 answer
Template MySQL Zabbix agent
SQL
1 vote221 views1 answer
Sql try catch
SQL