/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 vote217 views2 answers
Mysql type conversion
SQL
11 votes236 views2 answers
How to import mysql database command line
SQL
0 vote237 views1 answer
SELECT statement to find the specific cell in database table
SQL
4 votes208 views2 answers
What is table in sql
SQL
1 vote238 views1 answer
Sql not equal multiple columns
SQL
0 vote246 views1 answer
Mysql insert into select transaction c#
SQL
1 vote224 views1 answer
Oracle apex run 404
SQL
0 vote229 views1 answer
Create mysql pool connection python flask
SQL
1 vote223 views1 answer
Sql Split string function
SQL
0 vote187 views1 answer
Create bakupd database sqlserver
SQL