Profile it. Without profiling data, it is even useless to ask.
My first guess is that you are loading a lot of records into memory Marco Pivetta http://twitter.com/Ocramius http://ocramius.github.com/ On 1 July 2015 at 11:02, Utsav Sabharwal <[email protected]> wrote: > My web page is loading very slow. Its taking like 3 minutes to load. I > thought it must be because of slow database query. But I could not found > anything in the mysql process list. Then I checked php5-fpm slow query log > and found following entries: > > > > [30-Jun-2015 15:27:49] [pool www] pid 15717 > > script_filename = /var/www/sandbox/prateek/web/app.php > > [0x00007f5956872a78] createEntity() /var > /www/sandbox/prateek/vendor/doctrine/lib/Doctrine/ORM/UnitOfWork.php:2081 > > [0x00007f5956871110] createEntity() /var > /www/sandbox/prateek/vendor/doctrine/lib/Doctrine/ORM/Internal/Hydration/ > SimpleObjectHydrator.php:129 > > [0x00007f5956870da8] _hydrateRow() /var > /www/sandbox/prateek/vendor/doctrine/lib/Doctrine/ORM/Internal/Hydration/ > SimpleObjectHydrator.php:43 > > [0x00007f5956870b38] _hydrateAll() /var > /www/sandbox/prateek/vendor/doctrine/lib/Doctrine/ORM/Internal/Hydration/ > AbstractHydrator.php:99 > > [0x00007f59568704e0] hydrateAll() /var > /www/sandbox/prateek/vendor/doctrine/lib/Doctrine/ORM/Persisters/ > BasicEntityPersister.php:705 > > [0x00007f59568702a0] loadAll() /var > /www/sandbox/prateek/vendor/doctrine/lib/Doctrine/ORM/EntityRepository > .php:170 > > [0x00007f5956870180] findBy() /var > /www/sandbox/prateek/vendor/doctrine/lib/Doctrine/ORM/EntityRepository > .php:156 > > [0x00007f595686fc88] findAll() /var > /www/sandbox/prateek/vendor/symfony/src/Symfony/Bridge/Doctrine/Form/ > ChoiceList/EntityChoiceList.php:148 > > [0x00007f595686fb20] load() /var/www/sandbox/prateek/vendor/symfony/src/ > Symfony/Component/Form/Extension/Core/ChoiceList/ArrayChoiceList.php:46 > > [0x00007f595686f400] getChoices() /var > /www/sandbox/prateek/vendor/symfony/src/Symfony/Component/Form/Extension/ > Core/Type/ChoiceType.php:112 > > [0x00007f595686e9b0] buildView() /var > /www/sandbox/prateek/vendor/symfony/src/Symfony/Component/Form/Form.php: > 917 > > [0x00007f595686df68] createView() /var > /www/sandbox/prateek/vendor/symfony/src/Symfony/Component/Form/Form.php: > 927 > > [0x00007f595686d520] createView() /var > /www/sandbox/prateek/vendor/symfony/src/Symfony/Component/Form/Form.php: > 927 > > [0x00007f595686c928] createView() /var/www/sandbox/prateek/src/PrintVenue/ > OrderItemsBundle/Controller/OrderItemsAdminController.php:146 > > [0x00007fff9f779080] listAction() unknown:0 > > [0x00007f595686bbe8] call_user_func_array() /var > /www/sandbox/prateek/vendor/symfony/src/Symfony/Component/HttpKernel/ > HttpKernel.php:117 > > [0x00007f595686b9e0] handleRaw() /var > /www/sandbox/prateek/vendor/symfony/src/Symfony/Component/HttpKernel/ > HttpKernel.php:71 > > [0x00007f595686b5b8] handle() /var/www/sandbox/prateek/vendor/symfony/src/ > Symfony/Bundle/FrameworkBundle/HttpKernel.php:47 > > [0x00007f595686b368] handle() /var > /www/sandbox/prateek/app/bootstrap.php.cache:552 > > [0x00007f595686a068] handle() /var/www/sandbox/prateek/web/app.php:63 > > > [30-Jun-2015 15:27:56] [pool www] pid 15718 > > script_filename = /var/www/sandbox/prateek/web/app.php > > [0x00007f5956872a70] createFromFormat() /var > /www/sandbox/prateek/vendor/doctrine-dbal/lib/Doctrine/DBAL/Types/ > DateTimeType.php:53 > > [0x00007f5956871110] convertToPHPValue() /var > /www/sandbox/prateek/vendor/doctrine/lib/Doctrine/ORM/Internal/Hydration/ > SimpleObjectHydrator.php:85 > > [0x00007f5956870da8] _hydrateRow() /var > /www/sandbox/prateek/vendor/doctrine/lib/Doctrine/ORM/Internal/Hydration/ > SimpleObjectHydrator.php:43 > > [0x00007f5956870b38] _hydrateAll() /var > /www/sandbox/prateek/vendor/doctrine/lib/Doctrine/ORM/Internal/Hydration/ > AbstractHydrator.php:99 > > [0x00007f59568704e0] hydrateAll() /var > /www/sandbox/prateek/vendor/doctrine/lib/Doctrine/ORM/Persisters/ > BasicEntityPersister.php:705 > > [0x00007f59568702a0] loadAll() /var > /www/sandbox/prateek/vendor/doctrine/lib/Doctrine/ORM/EntityRepository > .php:170 > > [0x00007f5956870180] findBy() /var > /www/sandbox/prateek/vendor/doctrine/lib/Doctrine/ORM/EntityRepository > .php:156 > > [0x00007f595686fc88] findAll() /var > /www/sandbox/prateek/vendor/symfony/src/Symfony/Bridge/Doctrine/Form/ > ChoiceList/EntityChoiceList.php:148 > > [0x00007f595686fb20] load() /var/www/sandbox/prateek/vendor/symfony/src/ > Symfony/Component/Form/Extension/Core/ChoiceList/ArrayChoiceList.php:46 > > [0x00007f595686f400] getChoices() /var > /www/sandbox/prateek/vendor/symfony/src/Symfony/Component/Form/Extension/ > Core/Type/ChoiceType.php:112 > > [0x00007f595686e9b0] buildView() /var > /www/sandbox/prateek/vendor/symfony/src/Symfony/Component/Form/Form.php: > 917 > > [0x00007f595686df68] createView() /var > /www/sandbox/prateek/vendor/symfony/src/Symfony/Component/Form/Form.php: > 927 > > [0x00007f595686d520] createView() /var > /www/sandbox/prateek/vendor/symfony/src/Symfony/Component/Form/Form.php: > 927 > > [0x00007f595686c928] createView() /var/www/sandbox/prateek/src/PrintVenue/ > OrderItemsBundle/Controller/OrderItemsAdminController.php:146 > > [0x00007fff9f779080] listAction() unknown:0 > > [0x00007f595686bbe8] call_user_func_array() /var > /www/sandbox/prateek/vendor/symfony/src/Symfony/Component/HttpKernel/ > HttpKernel.php:117 > > [0x00007f595686b9e0] handleRaw() /var > /www/sandbox/prateek/vendor/symfony/src/Symfony/Component/HttpKernel/ > HttpKernel.php:71 > > [0x00007f595686b5b8] handle() /var/www/sandbox/prateek/vendor/symfony/src/ > Symfony/Bundle/FrameworkBundle/HttpKernel.php:47 > > [0x00007f595686b368] handle() /var > /www/sandbox/prateek/app/bootstrap.php.cache:552 > > [0x00007f595686a068] handle() /var/www/sandbox/prateek/web/app.php:63 > > > While the php5-fpm log had following related entry: > > > [30-Jun-2015 15:27:49] WARNING: [pool www] child 15717, script > '/var/www/sandbox/prateek/web/app.php' (request: "GET /app.php") > executing too slow (12.454455 sec), logging > > [30-Jun-2015 15:27:49] NOTICE: child 15717 stopped for tracing > > [30-Jun-2015 15:27:49] NOTICE: about to trace 15717 > > [30-Jun-2015 15:27:49] NOTICE: finished trace of 15717 > > [30-Jun-2015 15:27:56] WARNING: [pool www] child 15718, script > '/var/www/sandbox/prateek/web/app.php' (request: "GET /app.php") > executing too slow (12.867911 sec), logging > > [30-Jun-2015 15:27:56] NOTICE: child 15718 stopped for tracing > > [30-Jun-2015 15:27:56] NOTICE: about to trace 15718 > > [30-Jun-2015 15:27:56] NOTICE: finished trace of 15718 > > > I don't get why events such as createEntity are taking so much time to > execute. > > -- > You received this message because you are subscribed to the Google Groups > "doctrine-user" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/doctrine-user. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "doctrine-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/doctrine-user. For more options, visit https://groups.google.com/d/optout.
