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.
