Search code examples
symfonydoctrinearraycollection

Big ArrayCollection and Doctrine (symfony2)

I use Symfony for my website but I have a problem with the performance, I have a big ArrayCollection ( +50000 elements), in my doctrine query I did the differents joins but the page is too long to load. How I can optimise the loading of the page?

Thanks

Solution

  • Try to not load everything on a single page. Use pagination.

    Good choice is KnpPaginatorBundle.