doctrine/archived-orm
1
0
Fork 0
mirror of https://github.com/doctrine/orm.git synced 2026-03-24 06:52:09 +01:00
Code Issues 5.3k Packages Projects Releases 100 Wiki Activity

[PR #8073] Optimize paginator removing useless left joins in subselect #10798

New Issue
Open
opened 2026-01-22 16:08:43 +01:00 by admin · 0 comments
admin commented 2026-01-22 16:08:43 +01:00
Owner
Copy Link

Original Pull Request: https://github.com/doctrine/orm/pull/8073

State: closed
Merged: No

Hi

Here is a draft of what could be a huge performance boost for Paginator

Actually, to optimize database db queries, we could join nested fields but, when using it with the Paginator and some filters, the distinct subselect injected suffer of all that left joined data that could be removed on that subselect returning ids

I am not hoping that could be merge like this but it opens the discussion

Thanks in advance for your opinion and tips

**Original Pull Request:** https://github.com/doctrine/orm/pull/8073 **State:** closed **Merged:** No --- Hi Here is a draft of what could be a huge performance boost for Paginator Actually, to optimize database db queries, we could join nested fields but, when using it with the Paginator and some filters, the distinct subselect injected suffer of all that left joined data that could be removed on that subselect returning ids I am not hoping that could be merge like this but it opens the discussion Thanks in advance for your opinion and tips
admin added the pull-request label 2026-01-22 16:08:43 +01:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
BC Break
Bug
Can't Fix
Deprecation
Documentation
DQL
Duplicate
Failing Test
Hacktoberfest
Improvement
Improvement
Incomplete
Invalid
Missing Tests
New Feature
PR Created
pull-request
Mirrored from GitHub Pull Request
 Question
Regression
Status: Waiting feedback
Waiting feedback
WIP
Won't Fix
No Label pull-request
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
admin
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: doctrine/archived-orm#10798
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?