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.

Reply via email to