How can the loading time of a PHP page that reads from a database be reduced?

The loading time of a PHP page that reads from a database can be reduced by optimizing the database queries, using caching mechanisms like Memcached or Redis, minimizing the number of database queries, and using pagination to limit the amount of data fetched at once. 

<?php
// Example code snippet demonstrating how to reduce loading time by optimizing database queries and using pagination

// Connect to the database
$connection = new mysqli("localhost", "username", "password", "database");

// Check connection
if ($connection->connect_error) {
    die("Connection failed: " . $connection->connect_error);
}

// Implement pagination
$limit = 10; // Number of records per page
$page = isset($_GET['page']) ? $_GET['page'] : 1; // Get current page number

$start_from = ($page - 1) * $limit; // Calculate starting point for fetching records

// Query to fetch data with pagination
$sql = "SELECT * FROM table_name LIMIT $start_from, $limit";
$result = $connection->query($sql);

// Display fetched data
if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo "ID: " . $row["id"] . " - Name: " . $row["name"] . "<br>";
    }
} else {
    echo "0 results";
}

// Close database connection
$connection->close();
?>

Keywords

Database optimization PHP caching Lazy loading Indexing Query optimization

Related Questions