[DocumentDB] Allow Paging (skip/take)
Allowing paging would be huge. Btw, Thank You for rolling out this feature at all! It looks wonderful! Can't wait to try it! However, I won't be able to use it for actual work projects until it supports paging and sorting.
Reopening this user voice item as our support for Skip/Take (Offset/Limit) was only limited to single partition queries.
The newly released .NET SDK v3 now includes support for x-partition queries using Offset/Limit. You can learn more about v3 SDK and try it and provide feedback on our github repo here.
We will also be back-porting this functionality to our .NET v2 SDK. This work will begin shortly and we anticipate it to be released in September.
Once that is released we will mark this feature as complete.
Thank you for your patience and votes.
Pankaj Patro commented
Any simple client side programming feature like grid etc heavily relies on pagination to limit the load and performance. Without this simple feature I think cosmos DB is not meant to be used in Line of Business(LOB) applications...
Hello, the item for this feature, will it also benefit Gremlin API once it's ready? Would really love this feature for gremlin API
Very interested in that feature!
Great news, I'm wondering about the context of 'soon'.
We can't give an exact date but this is actively being worked on now and expect soon.
shanthu kere commented
Great news indeed! What is the ETA ?
Is this feature going to be available in only CosmosDB SQL API or Graph API as well?
come on guys its been years.... we need skip/take
Leng Yang commented
Paging (skip/take) is a required feature for hundreds of millions of rows. Any roadmap when this feature will be added.
Nick Chapsas commented
In the meantime, you could use Cosmonaut which supports PageSize/PageNumber pagination, integrate and then when native support is added the library will be updated as well. You can read more about it here: https://github.com/Elfocrash/Cosmonaut#pagination
We will work towards moving our platform to Cosmos once this feature is added.
Anthony BOUQUET commented
I need some updates too. paging is mandatory in our use case and we won't go on cosmo db until it will be featured.
Ezequiel Ramos commented
[Deleted User] commented
Lajos Marton commented
Finally, it will worth the money.
At this time, I can say we are working on some foundational pieces which will light up skip/take in future.
Without skip. I will not even bother with docdb. Its an absolutely essential thing. It seems funny to me it is not yet implemented. Must be difficult to achieve for some reason.
It’s interesting to note CosmosDB is promoted as a MonogDB compatible api yet skip is support on MongoDB and we seem to be getting nowhere quickly
Jason Kergosien commented
I have to agree with everyone. It's a big deal.
Even if it's not a typical NoSQL feature, it doesn't matter. I'm a convert to NoSQL thanks to Cosmos, but since I'm used to very good functionality with RDBMS, guess what, I expect a lot.
(You can only blame yourself (MS). You spoiled us with great features w/SQL Server :) )
Adoption has got to be a key metric for Cosmos, so this should be important to add.
My 2 cents. Thanks guys!