/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 vote267 views1 answer
Psql client write to bash variable
SQL
0 vote318 views2 answers
Pl sql auto increment
SQL
0 vote275 views1 answer
Oracle sql log to console
SQL
0 vote337 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
0 vote228 views1 answer
Calculate discount from original price sql
SQL
0 vote262 views1 answer
Sql server 2012 create or alter procedure
SQL
2 votes276 views2 answers
Sql query to copy data from one column to another
SQL
5 votes252 views3 answers
Truncate function in sql oracle
SQL
0 vote287 views1 answer
Reindex mssql table
SQL
1 vote308 views1 answer
Last 24 HOUR data in mysql
SQL