/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 vote321 views2 answers
Postgres default user
SQL
0 vote316 views1 answer
Find how many table doesn't contain column in mysql
SQL
2 votes304 views1 answer
Oracle drop table free up space
SQL
1 vote301 views1 answer
Oracle add proxy
SQL
1 vote336 views1 answer
Connect to mysql database ubuntu
SQL
7 votes357 views1 answer
Buy forge mods server hosting
SQL
0 vote283 views1 answer
Wordpress sql find and replace
SQL
1 vote304 views3 answers
How to truncate foreign key constraint table
SQL
2 votes314 views2 answers
Postgresql search all tables for column name
SQL
1 vote327 views1 answer
Sql server today minus n
SQL