When should I use EXTRA_LAZY instead of LAZY?

Use EXTRA_LAZY for very large collections where you only need to perform count, contains, or slice operations without loading the entire collection into memory.

Does it support DTOs for query results?

Absolutely, it demonstrates how to use the NEW operator in DQL to select data directly into non-entity objects for better performance in read-only list views.

How does this skill help with N+1 query issues?

It provides patterns for Join Fetching and query-level fetch mode overrides to ensure relations are loaded in a single query rather than multiple sequential calls.

Can this skill help with memory management in long-running processes?

Yes, it includes best practices for batch processing using toIterable() and periodic entity manager clearing to keep memory usage low.

Doctrine Performance & Fetch Modes

Name: Doctrine Performance & Fetch Modes
Author: MakFly

byMakFly

•

数据库管理

Optimizes Symfony Doctrine queries using fetch modes, lazy loading strategies, and advanced query hints to eliminate N+1 issues.

This skill empowers Claude to optimize database interactions within Symfony applications by implementing advanced Doctrine ORM strategies. It provides expert guidance on configuring LAZY, EAGER, and EXTRA_LAZY fetch modes, utilizing Join Fetch patterns to resolve N+1 performance bottlenecks, and employing partial objects or DTOs for memory-efficient data retrieval. Whether you are handling large collections with batch processing or fine-tuning queries with specific hints and read-only flags, this skill ensures your persistence layer remains scalable and performant.

主要功能

01Fine-tune query execution with Doctrine Query Hints and read-only mode

02Optimize memory usage with Partial Objects and Data Transfer Objects (DTOs)

03Implement EXTRA_LAZY collections for efficient handling of large datasets

04Manage large-scale data processing using iterable batch results and EM clearing

05Resolve N+1 query problems using explicit Join Fetching patterns

0621 GitHub stars

使用场景

01Designing high-performance API endpoints that retrieve nested entity relationships efficiently

02Refactoring legacy Symfony controllers to eliminate database performance bottlenecks

03Implementing background jobs that process millions of database records without memory exhaustion

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add makfly/superpowers-symfony doctrine-fetch-modes

For use in Claude.ai and ChatGPT

Download Skill