/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 vote277 views1 answer
Selecting Multiple Columns in SQL
SQL
4 votes235 views2 answers
How to count items with same name in sql
SQL
0 vote256 views3 answers
Create and attach user to a postgresql database
SQL
-1 vote301 views1 answer
Difference berween database and data base management system
SQL
0 vote248 views1 answer
Sql select min row
SQL
1 vote263 views2 answers
Regex starts with
SQL
15 votes252 views3 answers
Create table with primary key auto increment in sql
SQL
0 vote258 views2 answers
How to generate a unique random number in mysql
SQL
0 vote254 views1 answer
Como saber si tengo mysql instalado
SQL
4 votes240 views1 answer
Update table from another table oracle
SQL