Sylius: N+1 issue, thousands of DB querys on the taxons and products admin pages

[geraintp]

Sylius version affected: 1.6.4

Description
The taxon tree on the taxon and products admin page is querying for each taxon individually and then querying for each translation individually, the result is an enormous amount of DB queries being used instead of two. A site with 5000 categories with a single translation each results in 11.9k db queries per page load.

Steps to reproduce
have a large number of product categories and visit the admin panel taxon or product section.

Possible Solution
Eager Load the Taxons and their translations for these pages.

[geraintp]

the same issue is present in the frontend too.

[stale[bot]]

This issue has been automatically marked as stale because it has not had any recent activity. It will be closed in a week if no further activity occurs. Thank you for your contributions.

[geraintp]

Any progress on this issue?

[mamazu]

I suggest that translations should be eagerly loaded. This problem is also present with the translations of the attributes. In our shop we have 60 attributes and 4 locales and loading a product produces 1020 queries when loading a product to edit it.

[stale[bot]]

This issue has been automatically marked as stale because it has not had any recent activity. It will be closed in a week if no further activity occurs. Thank you for your contributions.

[mamazu]

This is still an issue in 1.8.