/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 vote112 views2 answers
Demmarrer un service mysql teminal cmd
SQL
6 votes101 views2 answers
Oracle undotbs usage
SQL
0 vote107 views1 answer
Mysql add to value
SQL
0 vote115 views1 answer
Sqlite3 update select
SQL
3 votes145 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
1 vote151 views1 answer
Psql client write to bash variable
SQL
0 vote108 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
2 votes71 views5 answers
Alter table primary key postgresql
SQL
34 votes106 views6 answers
Sql change data type
SQL
1 vote124 views1 answer
Check current sequence value postgres
SQL