Hi, read about this topics https://docs.djangoproject.com/en/3.1/ref/models/querysets/#select-related #for FK relations
https://docs.djangoproject.com/en/3.1/ref/models/querysets/#prefetch-related-objects # for M2M relations and read about pagination https://docs.djangoproject.com/en/3.1/topics/pagination/ maybe this 3 topics help you about optimization your applications Cheers On Wed, Feb 10, 2021 at 8:02 AM Mottaz Hegaze <trapper...@gmail.com> wrote: > Use pagination and select_related , prefetch_related. > > Also consider using caching > > Default django pagination will load all rows then paginate them , which > will consume time and hits on database. > > Search for a custom pagination solution that loads 10 rows by 10 rows as > an example > > On Wed, 10 Feb 2021, 3:55 pm kévin endelin, <en2lin.ke...@gmail.com> > wrote: > >> >> I am developing a django application, most of the views are tables, I am >> facing a problem the loading time of my page is extremely long. how can >> I do to optimize this, my data set represents more than 100,000 rows. thank >> you for your help ^^ >> >> -- >> 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+unsubscr...@googlegroups.com. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/django-users/9a30277b-78d4-49c7-ac0a-399717ed7fe3n%40googlegroups.com >> <https://groups.google.com/d/msgid/django-users/9a30277b-78d4-49c7-ac0a-399717ed7fe3n%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- > 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+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/CAHV4E-fByf5F%2B-x_TN%2B0Uo_u5VwqZ2__ff-DP24jS9kNJJ07Kw%40mail.gmail.com > <https://groups.google.com/d/msgid/django-users/CAHV4E-fByf5F%2B-x_TN%2B0Uo_u5VwqZ2__ff-DP24jS9kNJJ07Kw%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > -- att. Carlos Rocha -- 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+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAM-7rO1A5hKPePy3zN2pPS9pfxLvQO-HK1XZW%2BZ1tVexo63TBA%40mail.gmail.com.
