id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
33493	It's counter-intuitive how QuerySet.iterate() works with prefetch_related	abetkin	nobody	"Hi django fellows!

I've stumbled upon this code in the main branch: (see screenshot)

The usecase is iterating through a queryset with prefetch_related lookups specified.

Do I understand correctly that multiple database queries happen upon fetching every chunk, and also that multiple database connections are required?

If so, than I think it would be better just to prohibit the use of prefetch_related with QuerySet.iterate

"	Cleanup/optimization	closed	Database layer (models, ORM)	dev	Normal	wontfix			Accepted	0	0	0	0	0	0