Hi! 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/ . 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 and all the best, Adam On Sun, 19 Jul 2020 at 04:21, karthik challa <[email protected]> wrote: > Hi Experts, > > I am trying to execute a Django query (ORM) but my query is taking more > than 4 mins as the table have huge records. > > Here are the details > > 1> I am using left outer join to get count from other table > > 2>Django query > subject = Table1.objects.all().annotate(numItems=Count('table2.field')). > order_by('name') > > > > 3>Here I am converting the above query set to Raw sql > SELECT "table1"."id", "table1"."created_at", "table1"."name", COUNT( > "table2"."id") AS "numItems" <http://localhost:8000/urls/search/#> FROM > "table1" LEFT OUTER JOIN "table2" ON ("table1"."id" = "table2". > "subdomain_id") GROUP BY "table1"."id" ORDER BY "table1"."name" ASC > > and I am returning response to template index.html > > response = render(request, 'search_home.html', context) > > > My template looks like this > {% if context.subject %} > {% for item in context.subject %} > {{ item }} > {% endfor %} > {% endif %} > Please let me know how can i reduce the performance time or how can i > optimize the query . > > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-developers/ab90edb2-7d5e-4e01-9fad-0c71cb916a67o%40googlegroups.com > <https://groups.google.com/d/msgid/django-developers/ab90edb2-7d5e-4e01-9fad-0c71cb916a67o%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- Adam -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/django-developers/CAMyDDM1Qv0deA2s%2BfdLLarnV5ZJ-MM8pUzxDV4KtixYkm-0Dag%40mail.gmail.com.
