/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 vote316 views3 answers
Sql union
SQL
0 vote281 views1 answer
Mysql select last 15 minutes
SQL
0 vote280 views1 answer
Add sqlite3 in lumen
SQL
0 vote303 views1 answer
Changing name of column and datatype in sql
SQL
2 votes300 views1 answer
Sql to char function with date
SQL
1 vote284 views1 answer
Ilike for date postgres
SQL
0 vote239 views1 answer
Microsoft sql server management studio clear cache
SQL
0 vote307 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
1 vote243 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL
1 vote326 views1 answer
Nullif postgresql
SQL