/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 vote209 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL
0 vote204 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
2 votes188 views1 answer
Sql update from different table
SQL
0 vote174 views1 answer
How to use group_concat in sql server
SQL
0 vote194 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
50 votes202 views6 answers
Install mysql on ubuntu
SQL
0 vote238 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
2 votes201 views2 answers
Create temporary table in mysql
SQL
0 vote215 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
2 votes217 views1 answer
Tcl in sql
SQL