When listing content from taxonomies, Orchard is sending multiple sql queries per content item instead of grabbing all the data in one query. On my site, for a page listing 50 content items, it is sending 125 queries. This inefficiency wastes resources
and is slow to process.
I see the issue whether routing to a taxonomy term directly or using a projection of items that have a taxonomy field.