Managing Database Logic with Yii Active Record
Learn how to use Yii's Active Record to replace manual SQL with object-oriented CRUD, automate model creation with Gii, and solve the N+1 query problem.
Loading…
ReadMeFeed / Community knowledge
#orm
Real questions. Useful conversations. Find the people who know your stack.
yiiStopping the N+1 Leak: When to use select_related vs prefetch_related in Django
Stop the N+1 query problem in Django. Learn exactly when to use select_related for SQL joins and prefetch_related for Python-side lookups to optimize ORM performance.
python
djangoChoosing Between joinedload and selectinload in SQLAlchemy 2.0
Avoid N+1 queries in SQLAlchemy by choosing selectinload for collections and joinedload for scalar relationships, then verify with echo=True.
sqlalchemyStop N+1 Queries in CakePHP ORM with Contain
Use CakePHP ORM contain to eager load associations and avoid separate queries inside loops, with verification steps for CakePHP 4.x and 5.x.
cakephpReduce N+1 Selects in Hibernate with Batch Fetching
Configure Hibernate @BatchSize and hibernate.default_batch_fetch_size to load lazy associations in groups instead of one query per row.
hibernate
javaStopping the Offset Slide: Implementing Keyset Pagination in Hibernate
Stop database performance degradation in Hibernate by replacing Offset-based pagination with Keyset pagination (the Seek Method) for large datasets.
Tame CakePHP List Endpoints with Explicit Pagination and Contain
Unbounded find('all') queries with associations can crash CakePHP index actions. Build one ORM query, contain only what the template needs, and enforce limits with paginate().
Using SQLAlchemy joinedload to Stop N+1 Queries on Many-to-One Relations
Learn how SQLAlchemy's joinedload replaces N+1 queries with a single JOIN for many-to-one and one-to-one relations, when to use it, and what to watch out for.
Choosing Cursor‑Based Pagination in Hibernate to Avoid Offset Overhead
Learn why cursor‑based pagination outperforms Hibernate’s OFFSET‑based approach for large datasets and how to implement it safely.
jule