Re: Django Query optimizing performance (HUGE DATA)

2020-07-24 Thread Sci Mithilesh
WhatsApp number +918709440658 On Sun, 19 Jul 2020, 11:33 pm chinna, wrote: > Thank you Vishnu > > > On Sun, Jul 19, 2020 at 7:16 AM Vishnu Thuletiya < > vishnuthulet...@gmail.com> wrote: > >> I think you can use 'select_related(name of foreign key class) ' insted >> of all(). >> >> On Sun, 19 Ju

Re: Django Query optimizing performance (HUGE DATA)

2020-07-19 Thread chinna
Thank you Vishnu On Sun, Jul 19, 2020 at 7:16 AM Vishnu Thuletiya wrote: > I think you can use 'select_related(name of foreign key class) ' insted of > all(). > > On Sun, 19 Jul 2020, 9:11 am karthik challa, > wrote: > >> Hi Experts, >> >> I am trying to execute the below query and the query i

Re: Django Query optimizing performance (HUGE DATA)

2020-07-19 Thread karthik challa
My Apologies . On Sunday, July 19, 2020 at 3:06:57 AM UTC-4, Aymeric Augustin wrote: > > 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 b

Re: Django Query optimizing performance (HUGE DATA)

2020-07-19 Thread Vishnu Thuletiya
I think you can use 'select_related(name of foreign key class) ' insted of all(). On Sun, 19 Jul 2020, 9:11 am karthik challa, 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

Re: Django Query optimizing performance (HUGE DATA)

2020-07-19 Thread Aymeric Augustin
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 unli

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_