/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 vote341 views1 answer
Mysql add to value
SQL
2 votes369 views1 answer
Can you use a where clause for a child query
SQL
3 votes412 views2 answers
Savepoint in sql
SQL
3 votes350 views2 answers
Brew start mysql
SQL
0 vote349 views2 answers
SQL BULK INSERT
SQL
0 vote355 views1 answer
Mysql sql.gz
SQL
2 votes368 views1 answer
How to delete columns in sql
SQL
1 vote360 views1 answer
Mysql select all and rename one
SQL
1 vote344 views1 answer
Mysql get latest duplicate rows
SQL
0 vote362 views1 answer
Python connect to mysql in settings.py
SQL