Hello, I think you've found the wrong mailing list for this post. This mailing list is for discussing the development of Django itself, not for support using Django. This means the discussions of bugs and features in Django itself, rather than in your code using it. People on this list are unlikely to answer your support query with their limited time and energy.
For support, please follow the "Getting Help" page: https://docs.djangoproject.com/en/3.0/faq/help/ <https://docs.djangoproject.com/en/3.0/faq/help/> . This will help you find people who are willing to support you, and to ask your question in a way that makes it easy for them to answer. Thanks for your understanding! -- Aymeric. > On 19 Jul 2020, at 05:38, karthik challa <challakart...@gmail.com> 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 developers (Contributions to Django itself)" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to django-developers+unsubscr...@googlegroups.com > <mailto:django-developers+unsubscr...@googlegroups.com>. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-developers/996db826-fe18-4557-977b-58493c1f9481o%40googlegroups.com > > <https://groups.google.com/d/msgid/django-developers/996db826-fe18-4557-977b-58493c1f9481o%40googlegroups.com?utm_medium=email&utm_source=footer>. -- You received this message because you are subscribed to the Google Groups "Django developers (Contributions to Django itself)" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-developers+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/django-developers/CB478AA7-1F00-4E93-BAD6-423C78E702FA%40polytechnique.org.
