StackExchange.Redis.RedisServerException: 'OFFSET exceeds maximum of 10000'

cletisgipson 0
Viewed 20

Is there a way to get around this when using RediSearch FT.SEARCH?

I basically want to get all the possible results for a search. I can page through them using the LIMIT offset count parameters but it errors out when I hit an offset higher than 10000.

redisearch stackexchange.redis redis
2 Answers

It appears that when using redis/redis-stack-server you are limited to the offset number. I stood up an enterprise redis instance on azure and was able to use the limit with an offset higher than 100000.

cletisgipson0

You can change that 10000 ceiling by setting the MAXSEARCHRESULTS property. You can set it on the module installation, see https://redis.io/docs/stack/search/configuring/ like:

loadmodule ./redisearch.so MAXSEARCHRESULTS 100000

or at runtime on the CLI or via your client like:

127.0.0.1:6379> FT.CONFIG GET MAXSEARCHRESULTS
1) 1) MAXSEARCHRESULTS
   2) 10000
127.0.0.1:6379> FT.CONFIG SET MAXSEARCHRESULTS 100000
OK
127.0.0.1:6379> FT.CONFIG GET MAXSEARCHRESULTS
1) 1) MAXSEARCHRESULTS
   2) 100000
127.0.0.1:6379>
BSB0
Related