How can PHP be used to optimize the loading time of a webpage with a large database query?

When dealing with a large database query that may slow down the loading time of a webpage, one approach to optimize it is by using pagination. Pagination allows you to limit the number of results retrieved from the database at a time, reducing the overall load on the server and improving the loading time of the webpage. 

<?php
// Establish a database connection
$pdo = new PDO('mysql:host=localhost;dbname=your_database', 'username', 'password');

// Define the number of results per page
$results_per_page = 10;

// Get the current page number from the URL parameter
$page = isset($_GET['page']) ? $_GET['page'] : 1;

// Calculate the starting point for the query
$start = ($page - 1) * $results_per_page;

// Perform the database query with pagination
$stmt = $pdo->prepare("SELECT * FROM your_table LIMIT :start, :results_per_page");
$stmt->bindParam(':start', $start, PDO::PARAM_INT);
$stmt->bindParam(':results_per_page', $results_per_page, PDO::PARAM_INT);
$stmt->execute();

// Fetch and display the results
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    // Display the data from each row
}

// Display pagination links
// You can use the $page variable to generate pagination links
?>

Keywords

PHP database query optimization caching pagination lazy loading

Related Questions