/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 vote285 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
0 vote341 views3 answers
Postgres trim string
SQL
0 vote280 views1 answer
Sql server cannot create database diagram
SQL
1 vote298 views2 answers
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
SQL
0 vote303 views1 answer
Mysql récupérer le code création de vue
SQL
2 votes307 views1 answer
Ifnull postgres
SQL
1 vote283 views2 answers
Mysql extract month
SQL
1 vote334 views1 answer
Drop colum oracle 18c
SQL
7 votes280 views1 answer
Set sequence value oracle
SQL
0 vote282 views1 answer
Oracle list subpartitions
SQL