DoctrineORMModule - Log number of rows returned by query

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

DoctrineORMModule - Log number of rows returned by query

Griesi
Hi all,

 

I would like to see the number of rows returned from the database for each
query in the Zend Developer Tools. I would like to be able to quickly
identify expensive queries which do return a multiple of rows (because of
unfavorable joins) in relation to the number of entities finally needed. I
already looked in the code base and it seems that this cannot be done easily
with a dedicated collector without modifying Doctrine┬┤s core.  Am I wrong?
If yes how can it be implemented?  

 

Best Regards

Christian

 

 

Reply | Threaded
Open this post in threaded view
|

Re: DoctrineORMModule - Log number of rows returned by query

Marco Pivetta
The query logger doesn't log the number of retrieved records, since queries
may be buffered.

If you need to give it a shot, then you can just implement your own
collector and override the service name though.

Marco Pivetta

http://twitter.com/Ocramius

http://ocramius.github.com/


On 24 October 2013 11:06, Christian Ebert <[hidden email]> wrote:

> Hi all,
>
>
>
> I would like to see the number of rows returned from the database for each
> query in the Zend Developer Tools. I would like to be able to quickly
> identify expensive queries which do return a multiple of rows (because of
> unfavorable joins) in relation to the number of entities finally needed. I
> already looked in the code base and it seems that this cannot be done
> easily
> with a dedicated collector without modifying Doctrine┬┤s core.  Am I wrong?
> If yes how can it be implemented?
>
>
>
> Best Regards
>
> Christian
>
>
>
>
>
>