/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 vote364 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL
5 votes351 views1 answer
Oracle add time to date
SQL
5 votes326 views1 answer
Find table from column name in sql
SQL
1 vote346 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
17 votes320 views6 answers
Sql current date
SQL
1 vote328 views1 answer
Sql try catch
SQL
0 vote328 views1 answer
Count characters of string mysql
SQL
0 vote359 views2 answers
MySQL PARTITION BY month automatically
SQL
6 votes357 views3 answers
Rename column ORACLE
SQL
1 vote365 views1 answer
Login to database mysql terminal
SQL