#30256: autocomplete_fields cause one or two extra queries for each field wth
foreign key or many to many relation
--------------------------------------+------------------------------------
     Reporter:  George Tantiras       |                    Owner:  nobody
         Type:  Cleanup/optimization  |                   Status:  new
    Component:  contrib.admin         |                  Version:  master
     Severity:  Normal                |               Resolution:
     Keywords:  autocomplete          |             Triage Stage:  Accepted
    Has patch:  0                     |      Needs documentation:  0
  Needs tests:  0                     |  Patch needs improvement:  0
Easy pickings:  0                     |                    UI/UX:  0
--------------------------------------+------------------------------------

Comment (by brettdh):

 I think I'm having the same issue described here, but I'm using the
 autocomplete functionality built into Django 2. Also, I'm currently on
 PostgreSQL 9.6.15.

 George, does your last comment apply to Django 2 built-in autocomplete?
 i.e. if we upgrade to a later PostgreSQL, would you expect this issue to
 go away?

 I've also just remembered that we explicitly disable server-side cursors
 because we use pgbouncer and encountered this issue some time ago:
 https://code.djangoproject.com/ticket/28062 so I'm not sure if that
 workaround would work for us (if I'm even understanding it correctly).

-- 
Ticket URL: <https://code.djangoproject.com/ticket/30256#comment:11>
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/066.049f6a2e589b7b205da06b9f7affd0de%40djangoproject.com.

Reply via email to