Re: Django Query optimizing performance (HUGE DATA)

2020-07-19 Thread karthik challa
ngoproject.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, ka

Django Query optimizing performance (HUGE DATA)

2020-07-18 Thread karthik challa
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_

Query Optimization (Huge Data in the Database)

2020-07-18 Thread karthik challa
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.fiel