Re: [Django] #31507: Augment QuerySet.exists() optimizations to .union().exists().

27 views
Skip to first unread message

Django

unread,
Apr 23, 2020, 12:49:48 AM4/23/20
to django-...@googlegroups.com
#31507: Augment QuerySet.exists() optimizations to .union().exists().
-------------------------------------+-------------------------------------
Reporter: Simon Charette | Owner: nobody
Type: | Status: new
Cleanup/optimization |
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by felixxm):

* stage: Unreviewed => Accepted


--
Ticket URL: <https://code.djangoproject.com/ticket/31507#comment:2>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

Django

unread,
Nov 11, 2020, 5:28:04 PM11/11/20
to django-...@googlegroups.com
#31507: Augment QuerySet.exists() optimizations to .union().exists().
-------------------------------------+-------------------------------------
Reporter: Simon Charette | Owner: David
Type: | Wobrock
Cleanup/optimization | Status: assigned

Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by David Wobrock):

* cc: David Wobrock (added)
* owner: nobody => David Wobrock
* has_patch: 0 => 1
* status: new => assigned


Comment:

PR https://github.com/django/django/pull/13667

--
Ticket URL: <https://code.djangoproject.com/ticket/31507#comment:3>

Django

unread,
Nov 13, 2020, 3:45:12 AM11/13/20
to django-...@googlegroups.com
#31507: Augment QuerySet.exists() optimizations to .union().exists().
-------------------------------------+-------------------------------------
Reporter: Simon Charette | Owner: David
Type: | Wobrock
Cleanup/optimization | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0
Needs tests: 1 | Patch needs improvement: 1

Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by David Wobrock):

* needs_better_patch: 0 => 1
* needs_tests: 0 => 1


--
Ticket URL: <https://code.djangoproject.com/ticket/31507#comment:4>

Django

unread,
Nov 13, 2020, 5:26:04 PM11/13/20
to django-...@googlegroups.com
#31507: Augment QuerySet.exists() optimizations to .union().exists().
-------------------------------------+-------------------------------------
Reporter: Simon Charette | Owner: David
Type: | Wobrock
Cleanup/optimization | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by David Wobrock):

* needs_better_patch: 1 => 0
* needs_tests: 1 => 0


--
Ticket URL: <https://code.djangoproject.com/ticket/31507#comment:5>

Django

unread,
Nov 14, 2020, 5:27:41 AM11/14/20
to django-...@googlegroups.com
#31507: Augment QuerySet.exists() optimizations to .union().exists().
-------------------------------------+-------------------------------------
Reporter: Simon Charette | Owner: David
Type: | Wobrock
Cleanup/optimization | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 1

Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Mariusz Felisiak):

* needs_better_patch: 0 => 1


--
Ticket URL: <https://code.djangoproject.com/ticket/31507#comment:6>

Django

unread,
Nov 14, 2020, 12:46:12 PM11/14/20
to django-...@googlegroups.com
#31507: Augment QuerySet.exists() optimizations to .union().exists().
-------------------------------------+-------------------------------------
Reporter: Simon Charette | Owner: David
Type: | Wobrock
Cleanup/optimization | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0

Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by David Wobrock):

* needs_better_patch: 1 => 0


--
Ticket URL: <https://code.djangoproject.com/ticket/31507#comment:7>

Django

unread,
Nov 16, 2020, 1:02:12 AM11/16/20
to django-...@googlegroups.com
#31507: Augment QuerySet.exists() optimizations to .union().exists().
-------------------------------------+-------------------------------------
Reporter: Simon Charette | Owner: David
Type: | Wobrock
Cleanup/optimization | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Ready for
| checkin

Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Mariusz Felisiak):

* stage: Accepted => Ready for checkin


--
Ticket URL: <https://code.djangoproject.com/ticket/31507#comment:8>

Django

unread,
Nov 16, 2020, 2:54:09 PM11/16/20
to django-...@googlegroups.com
#31507: Augment QuerySet.exists() optimizations to .union().exists().
-------------------------------------+-------------------------------------
Reporter: Simon Charette | Owner: David
Type: | Wobrock
Cleanup/optimization | Status: closed

Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution: fixed

Keywords: | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Mariusz Felisiak <felisiak.mariusz@…>):

* status: assigned => closed
* resolution: => fixed


Comment:

In [changeset:"ba42569d5c01b58b2999e393f097b530e538ec41" ba42569d]:
{{{
#!CommitTicketReference repository=""
revision="ba42569d5c01b58b2999e393f097b530e538ec41"
Fixed #31507 -- Added QuerySet.exists() optimizations to compound queries.
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/31507#comment:9>

Reply all
Reply to author
Forward
0 new messages