We use doctrine paginator in zf2 for list pagination.
We tried to disable UseOutputWalkers because of performance gain - for some entities expected table size is in millions and we are paginating simple lists with some inner joins - but with UseOutputWalkers(false) and fetchJoinCollection=true (default) we get exception for queries ordering by referenced entity id.
- OK - DQL:
- Exception - Error producing an iterator - DQL:
Paginator SQL with error:
Same query with $fetchJoinCollection = false - OK - paginator SQL:
- using setUseOutputWalkers(true) generates most robust queries but count is really slow for 200k+ tables