Does not display many products in the admin. Sylius framework. What could be the problem?

Question

symfony

Good afternoon everyone. Is there anyone who knows sylius or at least symfony2, I have been suffering with the store for several days. There are 80k products in the store and in the admin panel I can’t get the list of products to be displayed. Just an empty page, although there is pagination, all configs are registered. If you leave 5000 products, then it somehow works, but I need everything (
I can’t understand what’s the matter, because it can’t be that it would drag everything for the request even with pagination set.
The indexAction method is responsible for displaying
. Thank you in advance.
codepaste.net /8tdazf

Answer 1

The line smells:
There is a possibility that the paginator unloads all the data, and then it paginates (which is extremely stupid). If these are the essences of the doctrine, then a lot of memory for 8k records will be eaten.
Look in the logs for what error.