/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 vote188 views1 answer
Kimball data warehouse sql calendar
SQL
1 vote151 views1 answer
Pl sql insert into table
SQL
0 vote159 views1 answer
Sql getdate minus 1 day without time
SQL
0 vote146 views9 answers
Linq to sql converter online
SQL
0 vote137 views1 answer
How to execute stored output to csv files
SQL
1 vote155 views3 answers
Default password of mysql
SQL
0 vote183 views1 answer
Add computed column to table sql server
SQL
0 vote153 views1 answer
Mysql Like(searching in the string)
SQL
0 vote170 views1 answer
Nodejs sql get one to many relationship as array
SQL
0 vote155 views1 answer
How to get first 10 records of a table in mysql
SQL