/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

36 votes291 views3 answers
Add column in mysq
SQL
6 votes256 views2 answers
WHERE value IS sql
SQL
0 vote260 views1 answer
Postgresql isnull with max
SQL
7 votes279 views1 answer
Sql pagination oracle
SQL
17 votes266 views3 answers
Postgresql version command
SQL
0 vote262 views1 answer
How to get table current identity value in sql server
SQL
8 votes270 views2 answers
Grant all privileges database postgres to user
SQL
0 vote237 views1 answer
Duplicate foreign key constraint name
SQL
2 votes260 views2 answers
Change mysql password from command line
SQL
0 vote272 views1 answer
How to import pymysql through jupyter notebook for windows
SQL