Take a look at Django’s select_related or prefetch_related.
https://docs.djangoproject.com/en/1.11/ref/models/querysets/#select-related
https://docs.djangoproject.com/en/1.11/ref/models/querysets/#prefetch-related
From: django-users@googlegroups.com [mailto:django-users@googlegroups.com]
On Behalf Of alukau2894@gmail.com
Sent: Thursday, October 12, 2017 1:19 AM
To: Django users
Subject: regarding how to minimize the access time of the website
Hello,
I have a table of 8 crore rows and joining it with three tables. Is their any method how can we optimize this issue at present it is taking lot of time to do this.
Thanks,
Raja
--
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
django-users+unsubscribe@googlegroups.com.
To post to this group, send email to
django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/6239cd63-df8c-4f3b-88de-ed075065bc17%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.