Duplicated queries for multiple unicorn templates

[hamidrabedi]

I'm attempting to leverage the reusability of templates and variables, but whenever I invoke "unicorn," it triggers all the queries again:

<div class="swiper-wrapper" id="multimedia__swiper--container">
    <!-- Multimedia Slide  -->
    <div class="swiper-slide">
        {% unicorn 'multimedia-list' multimedia=all_media %}
    </div>
    <!-- Multimedia Slide  -->
    <div class="swiper-slide">
        {% unicorn 'multimedia-list' multimedia=publications %}
    </div>
    <!-- Multimedia Slide -->
    <div class="swiper-slide">
        {% unicorn 'multimedia-list'  multimedia=videos %}
    </div>
    <!-- Multimedia Slide -->
    <div class="swiper-slide">
        {% unicorn 'multimedia-list' multimedia=galleries %}
    </div>
</div>

My View:

class MultiMediaListView(ListView):
    template_name = 'pages/multimedia-list.html'
    page_name = 'multimedia-list'
    page_title = _('Multi Media')
    crumb = _('Multi Media')
    context_object_name = 'multimedia'
    paginate_by = 6

    def get_queryset(self):
        return MultiMedia.objects.prefetch_related('videos', 'galleries').order_by('-created')

    def get_context_data(self, **kwargs: Any) -> Dict[str, Any]:
        context = super().get_context_data(**kwargs)

        multi_media = self.get_queryset()

        context["all_media"] = multi_media
        context["videos"] = multi_media.filter(type=GalleryChoices.VIDEOS)
        context["publications"] = multi_media.filter(type=GalleryChoices.PUBLICATIONS)
        context["galleries"] = multi_media.filter(type=GalleryChoices.PICTURES)

        return context

and unicorn view:

class MultimediaListView(UnicornView):
    multimedia: QuerySet[MultiMedia] = None

i also have a context processor:

def banner_renderer(request):
    return {
        "footer": Footer.objects.prefetch_related('links', 'organizers').first(),
        "policies": Policy.objects.all().order_by('id'),
        "catalogue": Catalogue.objects.first()
    }

So now the problem is that each time i call the unicorn view all the queries get called again, same as context processor queries! :

Have i done something wrong? or is it related to unicorn itself?

[adamghill]

Unicorn won't change how Django executes querysets normally. So, if Django would normally have duplicate database calls when a queryset is retrieved the same will happen in Unicorn. You might be able to cache the data or store it in the component maybe?

I can't quite tell what is going on here, but if you can create a replicate-able repo which I could try out I can help debug what is happening.