/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 vote153 views1 answer
Sql select data from one database and insert into a different database
SQL
0 vote152 views1 answer
Mariadb alter table add column if not exists example
SQL
3 votes146 views2 answers
Check data in table mysql
SQL
2 votes138 views2 answers
Mysql all columns
SQL
0 vote143 views1 answer
Turn on foreign keys check mysql
SQL
2 votes161 views1 answer
Mysql select true or false
SQL
0 vote143 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
1 vote163 views2 answers
Create a unqie constraint mysql
SQL
0 vote142 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
0 vote134 views1 answer
SQL Server format datetime
SQL