symfony2 doctrine how to remove related objects in query?

Question

I have, for example, a "products" entity and an "orders" entity and a "customers" entity. using doctrine, if I execute

return $this->getEntityManager()
        ->createQuery(
            'SELECT p FROM MyApplicationBundle:Products p ORDER BY p.name ASC'
        )
        ->getResult();

I get a collection of products with orders and customers related information. this collection is too big and I'm worried it can take too much memory. is there a way to take only the products information? I'd need it only for this query so I don't want to modify the relation in the product entity class.

thanks

You can specify the fields you to retrieve, for example.

Alex
– Alex

2015-02-18 10:56:22 +00:00
Commented Feb 18, 2015 at 10:56 — Alex
– Alex, Commented Feb 18, 2015 at 10:56

Paul T. Rawkeen · Accepted Answer · 2017-06-28 08:55:56Z

2

You can mark the association as Extra Lazy in your Entity, this should prevent it from being automatically included in your query.

edited Jun 28, 2017 at 8:55

Paul T. Rawkeen

4,1133 gold badges38 silver badges53 bronze badges

answered Feb 18, 2015 at 10:52

MichaelHindley

4933 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user3174311 Over a year ago

Thanks for your answer but I need all the informations in other part of the application, so I prefernot to change it in the doctrine definition

Collectives™ on Stack Overflow

symfony2 doctrine how to remove related objects in query?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related