Feeding prefetched results into new queryset

Hello,

for the rendering of one View I want to execute two queries:

class A(model.Model):
i = models.CharField(max_length=10)

class B(model.Model):
f = models.ManyToManyField(A, on_delete...)
j = models.CharField(max_length=10)


- All objects of type A
queryset1 = A.objects.all()
- All objects of type B prefetching the related objects of type A:
queryset2 = B.objects.prefetch_related('f')

Under these conditions the table A is SELECTEd twice: once all elements are picked up and the result is cached in queryset1. The second time the columns of table A are touched again, if they stay in relation to B objects.

Is there any way to feed into queryset2 the (prefetched) results from queryset1, so that the second SELECT ... FROM A can be prevented (and the join can still happen python-side in RAM)?

Thanks in advance for your answer
Dilian

--
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+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/0f964f60-d683-4338-bfea-e108d74e036a%40aegee.org.
For more options, visit https://groups.google.com/d/optout.