#27260: Performance Issue because of LEFT OUTER JOIN instead the better INNER
JOIN
-------------------------------------+-------------------------------------
Reporter: Sven R. Kunze | Owner: nobody
Type: | Status: closed
Cleanup/optimization |
Component: Database layer | Version: 1.8
(models, ORM) |
Severity: Normal | Resolution: invalid
Keywords: | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by Thomas Güttler):
Just for the records. We have performance issues on postgres because some
SQL statements have up to six OUTER joins.
Union and intersection would be easier to read for me (human being) and
maybe better to optimize for the postgres query planer.
--
Ticket URL: <https://code.djangoproject.com/ticket/27260#comment:8>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/065.85b8cab62c34e90041b935f51acfeb49%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
