/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 vote96 views1 answer
Ms sql - add one hour to time
SQL
0 vote145 views1 answer
Trigger vérifier stock
SQL
0 vote162 views1 answer
Sql count total by foreign key
SQL
0 vote151 views1 answer
WHERE not regex in SQL
SQL
0 vote149 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
22 votes125 views2 answers
Mysql show all tables
SQL
0 vote147 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
0 vote137 views1 answer
Coalesce for comma separated in sql server
SQL
1 vote171 views1 answer
Homebrew install mysql
SQL
1 vote157 views1 answer
Lpad function in sql oracle
SQL