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.
