/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

2 votes164 views1 answer
Install sqlite npm
SQL
0 vote197 views1 answer
Look at running processes redshift
SQL
0 vote170 views1 answer
Rename constraint postgresql
SQL
0 vote176 views1 answer
Mysql 8 geo to json
SQL
16 votes170 views3 answers
Tsql rename column name
SQL
2 votes185 views1 answer
How to get weekday from old date in sql
SQL
0 vote192 views2 answers
Pl sql auto increment
SQL
0 vote186 views2 answers
How covert into int in maria db
SQL
0 vote161 views8 answers
Convert sql query to linq online
SQL
4 votes158 views2 answers
How to count items with same name in sql
SQL