Django Query optimizing performance (HUGE DATA)

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)

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

Re: Custom collation support

I've written a proof of concept: https://github.com/django/django/pull/13207 The diff is quite small, though I'm not sure if there's something I'm doing wrong - this is my first foray into schema migration internals so I'm learning as I read the codebase. Tom On Fri, 17 Jul 2020 at 13:55, Tom Ca