If you sort in the repository though the service can not have to do this.
So now paging code is much better. Here is a snippet from a fix done for this forum...
We did confirm with sql profiler that the main query was only returning the requested page and not the entire set so it all works great.
So now paging code is much better. Here is a snippet from a fix done for this forum...
var query = _repository.ListReplies(threadId).AsPagination(index, count);
var totalPages = query.TotalPages;
var totalItems = query.TotalItems;
var posts = query.ToList();
We did confirm with sql profiler that the main query was only returning the requested page and not the entire set so it all works great.
1 years 7 months 1 days
ago by
jon
jon