/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 vote218 views1 answer
Sql composite key
SQL
0 vote212 views1 answer
Google sheets data validation custom formula filter
SQL
1 vote213 views1 answer
Local sql server
SQL
1 vote162 views1 answer
Convert money to varchar sql server
SQL
2 votes219 views1 answer
Get first n letter of department name in sql
SQL
0 vote222 views1 answer
Flush user resource mysql
SQL
0 vote227 views4 answers
First max salary in sql
SQL
5 votes204 views1 answer
Oracle asynchronous procedure
SQL
0 vote207 views1 answer
Getting next sequence value jpa postgress
SQL
2 votes214 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL