/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

4 votes396 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
0 vote342 views1 answer
How to get first 10 records of a table in mysql
SQL
9 votes367 views3 answers
Date format in sql
SQL
0 vote347 views1 answer
Mysql regex select
SQL
0 vote342 views1 answer
Data structures in sql
SQL
3 votes383 views1 answer
Sql set null
SQL
7 votes358 views2 answers
Mysql get year from date
SQL
-1 vote338 views2 answers
On update cascade
SQL
1 vote377 views1 answer
Sql select whole row max column
SQL
0 vote360 views1 answer
Sql last time database was accessed
SQL