According to this page:
http://www.llblgen.com/documentation/2.6/Using%20the%20generated%20code/SelfServicing/gencode_paging.htm
Paging is achieved through a cte query that only collects the necessary rows for the current "page"
However we have some querys that timeout, and investigations shows us that the entire collections is retrieved (via sql)
What can we be doing wrong?
Code:
itemCollection.GetMulti(filter, 0, sortExpression, relations, prefetchPath, pageNumber, maximumRows);