🔗 Fixing queries & adding indexes - Laravel in practice EP6

In this episode, Harris from Laravel News tackles the issue of excessive queries in a test environment. The focus is on optimizing the top customers method, which previously generated hundreds of n+1 queries.

• Ensuring relationships are loaded before accessing them to avoid n+1 query problems.
• Creating a lookup table to avoid repeated query executions.
• Adding database indexes to improve query efficiency.
• Reducing the number of queries from 400 to 4.
• Cutting query execution time from 187 milliseconds to 40 milliseconds.
• Highlighting the importance of leveraging database optimizations over PHP calculations.
• Preparing to explore further optimizations in the next episode.