You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I'm running "knplabs/knp-paginator-bundle": "2.8.0" pagination results in a list view. I'd like to know if it's possible to prevent run extra sql queries from to-many and to-one ORM relations. I've tried to ->setHint(UsesPaginator::HINT_FETCH_JOIN_COLLECTION, false) with no success. For example: I have a entity Order that has one-to-one relation with Cart. When I run my list with orders the class Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber\UsesPaginator make a extra sql query for each relation of Order. Is there a way to prevent this extra queries?
The text was updated successfully, but these errors were encountered:
Hi!
I'm running
"knplabs/knp-paginator-bundle": "2.8.0"
pagination results in a list view. I'd like to know if it's possible to prevent run extra sql queries from to-many and to-one ORM relations. I've tried to->setHint(UsesPaginator::HINT_FETCH_JOIN_COLLECTION, false)
with no success. For example: I have a entityOrder
that hasone-to-one
relation withCart
. When I run my list with orders the classKnp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber\UsesPaginator
make a extra sql query for each relation ofOrder
. Is there a way to prevent this extra queries?The text was updated successfully, but these errors were encountered: