MYSQL mysqli_num_rows vs Select count()

[Mohammed Mohammed Rasly]

I am currently working on optimizing our database queries and came across two options that perform the same task get row count. but might have varying levels of efficiency. I was hoping you could shed some light on which one would be faster and more effective in terms of performance.

Option 1:
$query = "SELECT * FROM tb";
$q = mysqli_query($conn, $query);
$row = mysqli_num_rows($q);

Option 2:
$query = "SELECT count(id) as num FROM tb";
$q = mysqli_query($conn, $query);
$row = mysqli_fetch_assoc($q);