Skip to content
Tagged articles

N+1 problem

7 articles · Page 1 of 1
Java Tech Workshop
Java Tech Workshop
Oct 19, 2026 · Backend Development

One @Trans Annotation Solves N+1 Queries and Data Translation in Spring Boot

This article introduces Easy-Trans, a Dromara open-source library that uses a single @Trans annotation to automatically handle five types of data translation—dictionary, simple join, cross-service RPC, enum, and custom—while eliminating N+1 queries through batch ID collection and single IN-clause or cache lookups, with configuration details and best practices for Spring Boot applications.

DromaraEasy-TransMyBatis Plus
0 likes · 14 min read
One @Trans Annotation Solves N+1 Queries and Data Translation in Spring Boot
Raymond Ops
Raymond Ops
Oct 18, 2026 · Databases

MySQL Index Optimization: Confirm Slow Queries, Prove Access Paths, Add Indexes Safely

This guide details a systematic approach to MySQL index optimization: verify slow queries using performance_schema and system metrics, prove access paths with EXPLAIN ANALYZE, create indexes with rollback strategies using ALGORITHM=INPLACE and LOCK=NONE, address deep pagination with keyset pagination and N+1 queries with batch loading, and validate improvements with latency percentiles and lock metrics.

EXPLAIN ANALYZEIndex OptimizationInnoDB
0 likes · 12 min read
MySQL Index Optimization: Confirm Slow Queries, Prove Access Paths, Add Indexes Safely
Senior Xiao Ying
Senior Xiao Ying
May 20, 2026 · Backend Development

Tired of N+1 Queries? Boost Your Spring Boot GraphQL Performance 40× with DataLoader

This article explains the N+1 query problem in a Spring Boot GraphQL service, demonstrates how DataLoader batches and caches requests to reduce database round‑trips, and provides step‑by‑step integration code, including dependency setup, schema definition, entity mapping, batch loader registration, and best‑practice recommendations.

Batch loadingDataLoaderGraphQL
0 likes · 8 min read
Tired of N+1 Queries? Boost Your Spring Boot GraphQL Performance 40× with DataLoader
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Nov 13, 2025 · Backend Development

Mastering @EntityGraph in Spring Boot 3: Eliminate N+1 Queries Efficiently

This article explains the classic N+1 query issue in Spring Data JPA, demonstrates how JPQL JOIN FETCH and the @EntityGraph annotation can declaratively load associations, and provides advanced examples—including named entity graphs and combining @EntityGraph with custom @Query—to improve performance and code maintainability.

EntityGraphJPAN+1 problem
0 likes · 8 min read
Mastering @EntityGraph in Spring Boot 3: Eliminate N+1 Queries Efficiently
Taobao Frontend Technology
Taobao Frontend Technology
Sep 28, 2021 · Backend Development

How DataLoader Solves the GraphQL N+1 Problem: Deep Dive into Batch & Cache Mechanics

This article explains the GraphQL N+1 performance issue, demonstrates how DataLoader batches and caches database calls to eliminate redundant queries, walks through its core TypeScript implementation—including batch scheduling, cache handling, and load methods—while providing practical examples and integration tips for real‑world GraphQL servers.

CachingDataLoaderGraphQL
0 likes · 28 min read
How DataLoader Solves the GraphQL N+1 Problem: Deep Dive into Batch & Cache Mechanics
ITPUB
ITPUB
Sep 24, 2020 · Backend Development

Designing GraphQL for Microservices: Key Challenges, Solutions, and Best Practices

This article explains what GraphQL is, how its type system and Relay standard work, the N+1 problem, and presents three architectural approaches—prefixing, schema stitching, and RPC composition—for integrating GraphQL into microservices, along with authentication, authorization, and routing considerations.

AuthenticationGraphQLN+1 problem
0 likes · 34 min read
Designing GraphQL for Microservices: Key Challenges, Solutions, and Best Practices