Hello , Prefetch_related can be helpful, see doc
https://docs.djangoproject.com/en/3.0/ref/models/querysets/#prefetch-related Regards, Damanjeet On Sun, 19 Jul 2020, 04:39 karthik challa, <[email protected]> wrote: > Hi Experts, > > I am trying to execute the below query and the query is taking more than 5 > minutes. > > Here are the details > > Model.py > > class Url(models.Model): > subdomain = models.ForeignKey(Subdomain, null=True, blank=True, > related_name='url_subdomain', on_delete=models.SET_NULL,db_index=True) > full_url = models.CharField(max_length=1000, unique=True, db_index=True) > class Meta: > ordering = ['full_url'] > > def __str__(self): > return self.full_url > > 1>Django query ORM > > subdomains = Subdomain.objects.all().annotate(numItems=Count( > 'url_subdomain')).order_by('name') > > 2>SQL Query > > SELECT "urls_subdomain"."id", "urls_subdomain"."created_at", > "urls_subdomain"."name", COUNT("urls_url"."id") AS "numItems" > <http://localhost:8000/urls/search/#> FROM "urls_subdomain" LEFT OUTER > JOIN "urls_url" ON ("urls_subdomain"."id" = "urls_url"."subdomain_id") > GROUP BY "urls_subdomain"."id" ORDER BY "urls_subdomain"."name" ASC > > 3>Templates > > {% if subdomains %} > <div id="step-filter-tag" class="mb4"> > <div class="b mb3">Subdomain</div> > <div class="overflow-auto" style="max-height: 16rem;"> > {% for item in subdomains %} > item > {% endfor %} > </div> > </div> > > {% endif %} > > Please let me know how can i optimize the preformance Thanks & Regards, > Karthik > > -- > You received this message because you are subscribed to the Google Groups > "Django users" 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-users/83c9f9a3-1a14-4729-b2cb-3abeb06a8b2fo%40googlegroups.com > <https://groups.google.com/d/msgid/django-users/83c9f9a3-1a14-4729-b2cb-3abeb06a8b2fo%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "Django users" 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-users/CAGLHGi5x-9QbD7HHyAc86%2B%3DnMGNS8NcUQGxjGtJ9qEwvE-pX-Q%40mail.gmail.com.
