I want to improve my queryset performance, I am using Pagination to return paginated response in django but its taking so much time

Asked Apr 02 '23 at 07:35

Active Apr 02 '23 at 08:43

Viewed 28 times

here is my pagination code over a queryset.

    query_end_time = time.time() - start
    
    print(query_end_time, "query_end_time")

    total_rows = query_set.count()

    number_of_pages = 0

    paginator = Paginator(query_set, number_of_rows)

    number_of_pages = paginator.num_pages

    page_number = request.GET.get("page_number")

    order_item = list(paginator.get_page(page_number))

    pagination_end_time = time.time() - start

    print(pagination_end_time, "pagination_end_time")

query time and pagination time

tried django pagination document but not landed to any conclusion

edited Apr 02 '23 at 08:43

Sumithran

6,217
4
40
54

asked Apr 02 '23 at 07:35

Praveen Singh

Show your actual query and relevant models? – Sumithran Apr 02 '23 at 08:44
query is working perfectly well as you can see in the query output. i am using select_related,values, filter, order_by and distinct to retrive dataset – Praveen Singh Apr 02 '23 at 10:29

I want to improve my queryset performance, I am using Pagination to return paginated response in django but its taking so much time

0 Answers0