/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 vote129 views1 answer
SQL: merging multiple row data in string
SQL
0 vote125 views1 answer
Drop-toys-table
SQL
1 vote131 views3 answers
Remove unique key from a table
SQL
0 vote138 views1 answer
Window function to forward fill
SQL
0 vote142 views1 answer
Import sql inside hide sql
SQL
1 vote124 views1 answer
How to change owner in postgres
SQL
0 vote126 views1 answer
Mysql select distinct date from timestamp
SQL
0 vote125 views2 answers
Sql query inner join 3 tables
SQL
0 vote140 views1 answer
Least spark sql
SQL
0 vote132 views2 answers
How to create a table from another table in sql derby
SQL