/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 vote168 views1 answer
Sql gather statistics to increase performance
SQL
0 vote181 views1 answer
Get the previous column of a table in mysql
SQL
2 votes216 views1 answer
Select from array in psql
SQL
15 votes235 views4 answers
Export mysql db using command line
SQL
14 votes192 views3 answers
How to add default constraint in mysql
SQL
0 vote170 views1 answer
C# datetime to sql server datetime
SQL
0 vote172 views1 answer
Downgrading sql localdb visual studio
SQL
0 vote193 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
0 vote145 views1 answer
Mariadb list tables
SQL
3 votes231 views1 answer
Oracle detect invalid password
SQL