PHP MySQLi mysqli_free_result()

mysqli_free_result()

The mysqli_free_result() function frees the memory occupied by query results. This is extremely important when working with large databases, as it prevents the script from consuming too many system resources.

EXAMPLE

<?php
$server = "localhost";
$username = "root";
$password = "";
$database = "mysqli_database";

$connection = mysqli_connect($server, $username, $password, $database);
$query = "SELECT * FROM mysqli_table";

if ($result = mysqli_query($connection, $query)) {
    // Here we would read data using fetch_assoc/fetch_row...
    
    // When we no longer need the data, we free up the memory
    // NOTE: This function deletes the temporary query data from the server's 
    // working memory (RAM). We do this immediately after finishing our 
    // reading loops, as it speeds up the performance of the entire website.
    mysqli_free_result($result);
}

mysqli_close($connection);

echo "Memory has been successfully freed.";
?>

RESULT

The result will be displayed here...

Frees memory as soon as the data is no longer needed.

Recommended for use with all SELECT type queries.

Improves server performance during more demanding operations.