/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

5 votes199 views2 answers
Sql conn
SQL
10 votes200 views4 answers
Mysql one week ago
SQL
13 votes235 views3 answers
List all the tables in sql
SQL
0 vote152 views1 answer
Oracle sql replace string in clob
SQL
5 votes208 views1 answer
Sort order on two columns sql
SQL
0 vote207 views1 answer
Sqlalchemy query return only n results
SQL
0 vote194 views1 answer
Sql python hwo to pass a list in paramerter
SQL
0 vote208 views2 answers
Update query with between in mysql
SQL
0 vote200 views1 answer
Alter table myisam to innodb
SQL
3 votes227 views2 answers
Oracle sql first day of month
SQL