/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

11 votes133 views4 answers
Query DISTINCT
SQL
2 votes133 views3 answers
Write sql query to find the second highest salary of employee
SQL
0 vote244 views1 answer
Running mysql from bash sc
SQL
1 vote148 views2 answers
Sql drop multiple columns if exists
SQL
0 vote173 views1 answer
Postgres foreign key multiple columns
SQL
-1 vote88 views1 answer
How to create script to connect to oracle database and run query
SQL
0 vote131 views1 answer
Mysql add comment to column
SQL
1 vote89 views1 answer
Metada in sql
SQL
1 vote154 views1 answer
Mysql curdate between two dates
SQL
0 vote145 views1 answer
Ver usuarios mysql
SQL