Why Doctrine don't use thoses methode ?
->setFirstResult($offset)
->setMaxResults($itemCountPerPage);
To me, pagination should not use a IN over an id list.
Le mardi 26 janvier 2016 14:55:06 UTC+1, Marco Pivetta a écrit :
>
> This seems to be happening due to too large page size in the pagination:
> that may cause the IN() condition to have more than 1000 elements in it...
>
> Marco Pivetta
>
> http://twitter.com/Ocramius
>
> http://ocramius.github.com/
>
> On 26 January 2016 at 14:16, Pat Tryçias <[email protected] <javascript:>
> > wrote:
>
>> I do have this at the top
>>
>> use DoctrineORMModule\Paginator\Adapter\DoctrinePaginator as
>> PaginatorAdapter;
>> use Doctrine\ORM\Tools\Pagination\Paginator as ORMPaginator;
>> use Zend\Paginator\Paginator as ZendPaginator;
>>
>>
>>
>> Le mardi 26 janvier 2016 13:34:12 UTC+1, Sander Marechal a écrit :
>>>
>>> On 01/26/2016 12:13 PM, Pat Tryçias wrote:
>>> > What could I look for into my code to find the reason why Doctrine is
>>> > adding this ?
>>>
>>> I'm pretty sure the paginator is adding the giant where clause. Where
>>> does the ORMPaginator class come from?
>>>
>>> --
>>> Sander
>>>
>> --
>> 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] <javascript:>.
>> To post to this group, send email to [email protected]
>> <javascript:>.
>> Visit this group at https://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 https://groups.google.com/group/doctrine-user.
For more options, visit https://groups.google.com/d/optout.
