We are using umbraco some time ago and we are so glad of the CMS but now we are working on bigger project and we have one problem when we are using uQuery.GetNodesByType("Post").Skip(someNumber).Take(nextPart).
It always read entire collection then call skip and take methods. It is the same when we are using Model.Children and ChildrenAsList. And our question is:
Is there any way to call skip and take without read entire collection from database.
We tested uQuery.GetNodesByType("Post"), Model.Children and ChildrenAsList and they worked fast when we have little nodes, but we tested them with over 6000 or more nodes and they wasn't worked fast.
We had the same case and when we used Examine, it also read whole collection.
Here is the architecture of our web site in umbraco admin:
Our question is how to execute skip and take methods without always getting all posts from db?
How to create fast pagination in umbraco
Hello.
We are using umbraco some time ago and we are so glad of the CMS but now we are working on bigger project and we have one problem when we are using uQuery.GetNodesByType("Post").Skip(someNumber).Take(nextPart).
It always read entire collection then call skip and take methods. It is the same when we are using Model.Children and ChildrenAsList. And our question is:
Is there any way to call skip and take without read entire collection from database.
We tested uQuery.GetNodesByType("Post"), Model.Children and ChildrenAsList and they worked fast when we have little nodes, but we tested them with over 6000 or more nodes and they wasn't worked fast.
We had the same case and when we used Examine, it also read whole collection.
Here is the architecture of our web site in umbraco admin:
Our question is how to execute skip and take methods without always getting all posts from db?
Best wishes,
Our team :)
is working on a reply...