/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 vote176 views1 answer
Drop unique
SQL
1 vote162 views1 answer
Reutrn string after character sql
SQL
0 vote164 views1 answer
Sql transact create cursor with dynamic tables
SQL
0 vote157 views1 answer
Deny select insert update delete sql
SQL
3 votes176 views3 answers
Mysql order by list
SQL
0 vote150 views1 answer
How to create an SQL save method in ruby
SQL
0 vote230 views1 answer
Get first monday of month sql
SQL
0 vote319 views1 answer
Mysql delete entire row on condition
SQL
0 vote173 views1 answer
Where in clause tsql
SQL
0 vote175 views1 answer
Cannot pip install mysqlclient
SQL