di you ever try an elastic search for indexing our categories product to
speed up?
On Sat, Jul 11, 2020 at 12:16 PM carlos <crocha09...@gmail.com> wrote:
> Hi, i need any advice for performance queries
> i have a model name Post
> post have m2m categories and fk author
>
> the index page show 7 categories in separated row
> i try performance
> this example
> queryset_global =
> Post.objects.filter(status__contains='publish').prefetch_related('category').select_related('author')
> then i make 7 queries for 7 categories show in index page.
>
> newscat1
> =
> queryset_global.filter(category__slug__contains="cat1_name").order_by('-date')[:5]
> newscat2
> =
> queryset_global.filter(category__slug__contains="cat2_name").order_by('-date')[:5]
> newscat3
> =
> queryset_global.filter(category__slug__contains="cat3_name").order_by('-date')[:5]
> newscat4
> =
> queryset_global.filter(category__slug__contains="cat4_name").order_by('-date')[:5]
> newscat5
> =
> queryset_global.filter(category__slug__contains="cat5_name").order_by('-date')[:5]
> newscat6
> =
> queryset_global.filter(category__slug__contains="cat6_name").order_by('-date')[:5]
> newscat7
> =
> queryset_global.filter(category__slug__contains="cat7_name").order_by('-date')[:5]
>
> i retrieve 35 post for show in index page
>
> *according debug toolbar this produce SQL*
> *2599.59 ms (44 queries including 34 duplicates )*
>
> Why?
>
> but when i loop in template index.html
> {% for news1 in newscat1 %}
> {{news.name}}
> {{newa.date|date:'Y-m-d'}}
> {{news.body|safe|truncatewords:20}}
> {{news.category.all.0}}
> <a href="{{news.get_absolute_url}}">Read More</a>
> {% endfor %}
> ...
> this repeat in the template 7 time
> ...
> {% for news7 in newscat7 %}
> {{news.name}}
> {{newa.date|date:'Y-m-d'}}
> {{news.body|safe|truncatewords:20}}
> {{news.category.all.0}}
> <a href="{{news.get_absolute_url}}">Read More</a>
> {% endfor %}
>
>
> *according debug toolbar this produce SQL*
> *3463.65 ms (86 queries including 77 duplicates )*
>
> this is incredible it doubles the amount of queries to the db that may be
> happening?
>
> i need some ideas or tips
>
> Cheers
>
> --
> 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-7rO1nzzqWf_cpQOrjYwQmxkd77H0AJ8W03FS%3D%2BoA3gEE4zg%40mail.gmail.com
> <https://groups.google.com/d/msgid/django-users/CAM-7rO1nzzqWf_cpQOrjYwQmxkd77H0AJ8W03FS%3D%2BoA3gEE4zg%40mail.gmail.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/CAHGmjWU4XjJpXPzRQeWCEfMHBmP_zNZFCX5RpsFPTME1YLBdEA%40mail.gmail.com.
