/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 votes350 views2 answers
Sql server date now
SQL
2 votes329 views1 answer
Import large .sql files into lampp
SQL
0 vote363 views1 answer
Oracle swap partition
SQL
0 vote327 views1 answer
Sum value by month sql
SQL
2 votes362 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote398 views1 answer
Delete hangfire retries list
SQL
0 vote366 views2 answers
Mysql two column combination unique
SQL
0 vote327 views1 answer
Add timestamp column to existing table ms sql server
SQL
2 votes361 views1 answer
Revokeprivileges mysql
SQL
5 votes318 views1 answer
List foreign key oracle
SQL