/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 vote349 views1 answer
Lpad function in sql oracle
SQL
0 vote382 views1 answer
What alter does in db
SQL
0 vote371 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
0 vote343 views1 answer
Postgresql isnull with max
SQL
14 votes366 views3 answers
Oracle sql limit results
SQL
17 votes360 views6 answers
Get last record in sql
SQL
2 votes354 views2 answers
Mysql date range
SQL
1 vote399 views1 answer
Login to database mysql terminal
SQL
0 vote398 views1 answer
Sql date with year
SQL
0 vote356 views1 answer
Mysql regex exact match
SQL