/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

18 votes112 views6 answers
Laravel form validation
SQL
5 votes153 views3 answers
Sql limit offset
SQL
0 vote110 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote101 views1 answer
Get number of table colums in sql query
SQL
0 vote117 views1 answer
Mysql error codeigniter
SQL
2 votes80 views2 answers
Mysql get last character of string
SQL
1 vote109 views1 answer
GROUP BY clause; this is incompati
SQL
1 vote113 views1 answer
Woocommerce mysql price table
SQL
1 vote134 views1 answer
Oracle dbms scheduler repeat interval every 5 minutes
SQL
1 vote139 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL