/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 vote116 views1 answer
What is metadata in sql
SQL
0 vote146 views1 answer
Sql to excel pgadmin
SQL
0 vote124 views1 answer
Create table split string function in sql server
SQL
2 votes115 views1 answer
Alter table add multiple columns postgresql
SQL
19 votes115 views2 answers
Mysql tinyint max value
SQL
0 vote123 views1 answer
Postgresql log
SQL
-1 vote153 views4 answers
Sql view postgresql
SQL
0 vote119 views1 answer
Oracle right characters
SQL
0 vote117 views1 answer
Starting mysql shell lampp ubuntu
SQL
0 vote186 views1 answer
Mysql update all record removing 2 hours from column
SQL