/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

2 votes202 views1 answer
Mariadb json select
SQL
0 vote194 views1 answer
Sql server select ignore dupplicates
SQL
0 vote245 views1 answer
Duplicate table: 7 ERROR: relation "migrations" already exists (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))
SQL
0 vote214 views1 answer
Java nosql sort
SQL
0 vote220 views1 answer
How to insert multiple values in a single column in sql
SQL
3 votes191 views1 answer
Select table column in sql
SQL
5 votes200 views3 answers
Postgres show databases
SQL
8 votes205 views1 answer
Sql limit results returned
SQL
0 vote197 views1 answer
Sql pad left 0
SQL
0 vote205 views2 answers
Disallowed function mysql to_date()
SQL