Is it advisable to re-fetch data from a database in PHP, or should data already retrieved be stored and reused instead?

It is generally advisable to store data that has already been retrieved from a database and reuse it instead of re-fetching it. This can help improve performance by reducing the number of database queries and overall load on the database server. One common approach is to store the retrieved data in variables or arrays and reuse them as needed throughout the PHP script. 

// Example of storing retrieved data in a variable and reusing it
$data = []; // Initialize an empty array to store data

// Retrieve data from the database
$query = "SELECT * FROM table";
$result = mysqli_query($connection, $query);

// Store the retrieved data in the $data array
while ($row = mysqli_fetch_assoc($result)) {
    $data[] = $row;
}

// Now $data array can be reused throughout the script
foreach ($data as $row) {
    // Process each row of data
}

Keywords

database data retrieval caching performance optimization

Related Questions