Skip to content

Performance¶

March 26, 2026
in Database, Performance
12 min read

Database Indexing

What is an Index?

A database index is a data structure that improves the speed of read operations on a table or collection at the cost of additional storage and slower writes. Think of it like a book index — instead of scanning every page to find a topic, you look up the topic in the index and jump directly to the right page.

March 26, 2026
in Database, Performance, Laravel, ORM
4 min read

N+1 Query Problem

What is the N+1 Problem?

The N+1 problem is a common performance anti-pattern in database access where an application executes 1 query to fetch a list of parent records, then N additional queries to fetch related data for each parent — resulting in N+1 total queries instead of a constant number.