/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

3 votes173 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
1 vote148 views1 answer
Moodle query item quiz
SQL
37 votes196 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
1 vote183 views2 answers
Sql select only row with the max date
SQL
0 vote173 views1 answer
Delete ids between sql
SQL
3 votes147 views2 answers
Mysql add 2 hours
SQL
0 vote155 views1 answer
Not equal to blank in mysql
SQL
0 vote162 views2 answers
Close external port 3306 with iptables
SQL
2 votes152 views6 answers
In in sql
SQL
8 votes139 views1 answer
Sql remove characters from string right
SQL