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

•

Database Management

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

About

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.

Key Features

Fine-tune query execution with Doctrine Query Hints and read-only mode
Optimize memory usage with Partial Objects and Data Transfer Objects (DTOs)
Implement EXTRA_LAZY collections for efficient handling of large datasets
Manage large-scale data processing using iterable batch results and EM clearing
Resolve N+1 query problems using explicit Join Fetching patterns
21 GitHub stars

Use Cases

Designing high-performance API endpoints that retrieve nested entity relationships efficiently
Refactoring legacy Symfony controllers to eliminate database performance bottlenecks
Implementing background jobs that process millions of database records without memory exhaustion

About

Key Features

Fine-tune query execution with Doctrine Query Hints and read-only mode
Optimize memory usage with Partial Objects and Data Transfer Objects (DTOs)
Implement EXTRA_LAZY collections for efficient handling of large datasets
Manage large-scale data processing using iterable batch results and EM clearing
Resolve N+1 query problems using explicit Join Fetching patterns
21 GitHub stars

Use Cases

Designing high-performance API endpoints that retrieve nested entity relationships efficiently
Refactoring legacy Symfony controllers to eliminate database performance bottlenecks
Implementing background jobs that process millions of database records without memory exhaustion