How can the use of mysqli_num_rows be optimized for better performance in PHP?

When using mysqli_num_rows in PHP to count the number of rows returned by a query, it is important to optimize its performance by fetching the count directly from the database without unnecessary data transfer. This can be achieved by using SQL's COUNT() function in the query itself to retrieve the count of rows, rather than fetching all the rows and then counting them with mysqli_num_rows. 

// Example of optimizing mysqli_num_rows for better performance
$query = "SELECT COUNT(*) as total_rows FROM your_table WHERE your_condition";
$result = mysqli_query($connection, $query);
$row = mysqli_fetch_assoc($result);
$total_rows = $row['total_rows'];

echo "Total rows: " . $total_rows;

Keywords

mysqli_num_rows optimization performance PHP database

Related Questions