/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 vote334 views1 answer
Oracle create job if not exists
SQL
0 vote344 views1 answer
Sql how to get courses that i have made prerequisites
SQL
-1 vote333 views2 answers
Postgresql user permissions to database
SQL
5 votes372 views1 answer
Oracle source query
SQL
0 vote326 views4 answers
Mysql on kubernetes
SQL
0 vote326 views1 answer
How convert into in in sql query
SQL
1 vote372 views1 answer
Drop colum oracle 18c
SQL
38 votes420 views6 answers
Ubuntu install mysql client
SQL
1 vote374 views1 answer
Delete dublicate rows sql
SQL
0 vote336 views1 answer
Sqlcmd no headers
SQL