Query optimization in Laravel - Mini Project: Build & Apply

Query Optimization in Laravel

📖 Scenario: You are building a Laravel application that shows a list of books with their authors. You want to make sure the database queries are efficient to keep the app fast.

🎯 Goal: Learn how to optimize Laravel database queries by using eager loading to reduce the number of queries.

📋 What You'll Learn

Create a Book model with a relationship to Author

Set a variable for the maximum number of books to fetch

Write a query to get books with their authors using eager loading

Return the books data ready for display

💡 Why This Matters

🌍 Real World

Optimizing database queries in Laravel apps improves speed and user experience, especially when dealing with related data.

💼 Career

Understanding eager loading and query limits is essential for Laravel developers to write efficient, scalable applications.

1

Create the Book model with author relationship

Create a Laravel Book model class with a method author() that defines a belongsTo relationship to the Author model.

Laravel

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Book extends Model
{
    // Define author relationship here
}

Need a hint?

Use belongsTo inside the author() method to link to the Author model.

2

Set the maximum number of books to fetch

Create a variable called $maxBooks and set it to 10 to limit the number of books fetched.

Laravel

belongsTo(Author::class);
    }
}

// Set the maximum number of books to fetch
// Your code here

Need a hint?

Just create a variable $maxBooks and assign it the number 10.

3

Write a query to get books with authors using eager loading

Write a Laravel query using the Book model to get books with their authors using with('author') and limit the results to $maxBooks. Store the result in a variable called $books.

Laravel

belongsTo(Author::class);
    }
}

$maxBooks = 10;

// Get books with authors using eager loading
// Your code here

Need a hint?

Use Book::with('author')->limit($maxBooks)->get() to fetch books and their authors efficiently.

4

Return the books data for display

Return the $books variable from a controller method or function to complete the data retrieval process.

Laravel

belongsTo(Author::class);
    }
}

$maxBooks = 10;

$books = Book::with('author')->limit($maxBooks)->get();

// Return the books data
// Your code here

Need a hint?

Simply write return $books; to complete the data retrieval.