Fix Django N+1 Queries with select_related and prefetch_related
A Django template looping over related objects can silently issue hundreds of queries. Learn when to use select_related versus prefetch_related, and how to verify the fix.
Loading…
ReadMeFeed / Community knowledge
#query-optimization
Real questions. Useful conversations. Find the people who know your stack.
djangoOptimizing Couchbase N1QL Queries with Composite Global Secondary Indexes
When N1QL queries turn full-table scans on growing datasets, a strategically composite GSI can restore sub-millisecond latency without application changes.
couchbaseOptimizing SurrealDB Graph Traversals: Resolving Query Latency
Diagnose and fix SurrealDB graph traversal latency by identifying missing indexes, analyzing query plans with EXPLAIN, and applying targeted indexing strategies for RELATE and FETCH operations.
surrealdbCutting Django Query Latency: When and How to Use select_related vs. prefetch_related
When your Django view pulls many related objects, you may hit the N+1 query problem. Learn how to choose between select_related and prefetch_related, see a concrete example, and understand the trade‑offs to reduce latency and memory usage.
Boost EF Core Read‑Only Query Performance with AsNoTracking
Learn how to use EF Core’s AsNoTracking to skip change‑tracking, cut query time, and avoid unnecessary memory use. Includes a step‑by‑step guide, a concrete example, and verification tips.
entityframeworkcoreAvoiding N+1 in Django: When to Use select_related vs prefetch_related
Learn how to detect and fix N+1 queries in Django views by choosing between select_related and prefetch_related. Includes a worked example, trade‑offs, and a practical checklist.
Conditionally Include or Omit GraphQL Fields with @skip and @include
Control which fields a GraphQL query returns using Boolean variables and the @skip and @include directives, without changing the query structure.
graphqlselect_related vs prefetch_related: Fixing Django N+1 Queries
Stop N+1 queries in Django by choosing select_related for foreign keys and prefetch_related for many-valued relations, then verify with SQL logging.
Phoenix Secondary Indexes: Choosing Global vs. Local Without Doubling Your Writes
Phoenix secondary indexes are separate HBase tables, not magic. Learn when a global index is worth the synchronous write cost, when a local index fits your access pattern, and how covering columns trade storage for read speed.