/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 vote83 views1 answer
Jooq finding lastest value in table
SQL
1 vote104 views1 answer
Duplicating a MySQL table with all the data Command
SQL
1 vote133 views1 answer
How do you use sql in you company
SQL
0 vote97 views2 answers
Mysql regexp match word
SQL
0 vote108 views1 answer
Sql server pivot rows to columns
SQL
5 votes111 views1 answer
Get column name sql server
SQL
0 vote114 views1 answer
Character count sql
SQL
0 vote105 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
0 vote100 views1 answer
Sql database connectivity
SQL
5 votes101 views1 answer
Sql use database
SQL