/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

1 vote238 views1 answer
Sqlalchemy on delete set null
SQL
17 votes204 views5 answers
Order by sql
SQL
0 vote171 views1 answer
Sqlite3 now
SQL
4 votes196 views4 answers
Pl sql output
SQL
2 votes174 views1 answer
Oracle sql concatenate results into string
SQL
0 vote199 views1 answer
Update top 100 order by sql server
SQL
0 vote179 views1 answer
SQL loop with cursor
SQL
0 vote185 views1 answer
Oracle character index
SQL
1 vote199 views1 answer
Sql convert month name to number
SQL
0 vote190 views1 answer
Alter table add check constraint oracle
SQL