/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 vote138 views1 answer
Python mysql query to dataframe
SQL
0 vote122 views1 answer
How to to get current date and time in sql
SQL
0 vote150 views2 answers
Mysql insert into multiple tables
SQL
2 votes206 views1 answer
Postgresql group by month and year
SQL
0 vote138 views1 answer
Get first 3 letter of department name in sql
SQL
-1 vote138 views1 answer
How to change the auto increment in existing table mysql
SQL
0 vote132 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
0 vote147 views1 answer
Sql server union if table exist
SQL
22 votes159 views3 answers
Sql cheat sheet
SQL
0 vote128 views1 answer
Sql change primary key to composite key
SQL