Eliminate the N+1 Query Anti‑Pattern: Strategies to Boost Database Performance

This article explains why executing many small database queries in a short time harms performance, shows how to detect the N+1 problem with monitoring and logs, and presents refactoring techniques such as eager loading, batch operations, aggregation, caching, and hand‑crafted SQL to dramatically improve speed, scalability, and code quality.

Database PerformanceN+1 QuerySQL Optimization

0 likes · 9 min read

Eliminate the N+1 Query Anti‑Pattern: Strategies to Boost Database Performance

Code Ape Tech Column

Jul 14, 2023 · Backend Development

Understanding Ribbon Load Balancing and Eager Load Mode in Feign Clients

This article explains how Feign relies on Ribbon for remote calls, details Ribbon's load‑balancing mechanisms, various balancing rules, and demonstrates how enabling Ribbon's eager‑load mode can pre‑warm clients to avoid the latency of the first request.

JavaMicroservicesRibbon

0 likes · 6 min read

Understanding Ribbon Load Balancing and Eager Load Mode in Feign Clients

Laravel Tech Community

Jun 13, 2020 · Backend Development

Understanding Eager Loading in Laravel Eloquent

This article explains Laravel Eloquent's eager loading techniques, demonstrating how to replace lazy-loaded N+1 queries with the with() method, preload multiple or nested relationships, select specific columns, apply constraints, and use lazy eager loading methods like load and loadMissing, all illustrated with PHP code examples.

BackendEloquentLaravel

0 likes · 6 min read