OFFSET exceeds maximum of 10000

See original GitHub issue
   at Redis.OM.RedisConnection.ExecuteAsync(String command, String[] args)
   at Redis.OM.RediSearchCommands.SearchAsync[T](IRedisConnection connection, RedisQuery query)
   at Redis.OM.Searching.RedisCollectionEnumerator`1.GetNextChunkAsync()
   at Redis.OM.Searching.RedisCollectionEnumerator`1.MoveNextAsync()
   at Redis.OM.Searching.RedisCollection`1.ToListAsync()
   at Redis.OM.Searching.RedisCollection`1.ToListAsync()

So I’ m not sure what’s going on as I’m using paging elsewhere and not having this issue. (Maybe my paging is not triggering these levels)

I’m using the following code:

var results = await RedisDb.TransactionRecord.Where(x => x.TransactionTimeSearch > 0)
   .AsQueryable()
   .OrderBy(x => x.TransactionTimeSearch)
   .Skip(30000)
   .Take(100)
   .AsRedisCollection()
   .ToListAsync();

Does this mean the ability tp page through collections are limited to 10000 records and you can’t skip through larger collections?

Issue Analytics

  • State:closed
  • Created a year ago
  • Comments:10 (6 by maintainers)

github_iconTop GitHub Comments

1reaction
slorello89commented, Jul 5, 2022

cc’ing @chayim, but I’d still open the issue in that repo so it get’s in front of them 😃

0reactions
slorello89commented, Jul 5, 2022

Hey Charles, I’d say open an issue in the redis-stack repo?

Read more comments on GitHub >

github_iconTop Results From Across the Web

OFFSET exceeds maximum of 10000
I stood up an enterprise redis instance on azure and was able to use the limit with an offset higher than 100000.
Read more >
Aggregate limit greater than 10000 in nredisearch · Issue #27
Hi everyone, Is it possible to set limi greater than 10000 in nredisearch aggregate? My aggregate can grow to be more than 1...
Read more >
OFFSET limit exceeds while implementing pagination for ...
As the capacity to fetch the getQueryLocator is of 10,000 I can't event directly fire a query without using limit clause (shown below)...
Read more >
Retirement Plans FAQs regarding Loans
The maximum amount that the plan can permit as a loan is (1) the greater of $10,000 or 50% of your vested account...
Read more >
OFFSET LIMIT (NoSQL query) - Azure Cosmos DB
For example, you should use OFFSET LIMIT if you want to skip to the 1000th query result and have no need to view...
Read more >

github_iconTop Related Medium Post

No results found

github_iconTop Related StackOverflow Question

No results found

github_iconTroubleshoot Live Code

Lightrun enables developers to add logs, metrics and snapshots to live code - no restarts or redeploys required.
Start Free

github_iconTop Related Reddit Thread

No results found

github_iconTop Related Hackernoon Post

No results found

github_iconTop Related Tweet

No results found

github_iconTop Related Dev.to Post

No results found

github_iconTop Related Hashnode Post

No results found