/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

16 votes222 views1 answer
Sql comment'
SQL
1 vote189 views1 answer
Sql upsert
SQL
16 votes213 views2 answers
Oracle ddl
SQL
0 vote215 views1 answer
Hou to run job from cmd .exe sql server jop
SQL
1 vote219 views1 answer
Oracle convert run duration to number
SQL
1 vote191 views1 answer
What is intersect
SQL
4 votes187 views1 answer
Oracle table statistics last analyzed
SQL
1 vote206 views2 answers
Snowflake alter column data type
SQL
1 vote213 views1 answer
Mysql find most common value
SQL
0 vote205 views1 answer
Drop column from table if exist on live server mysql
SQL