Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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.

like image 510
cletisgipson Avatar asked Oct 20 '25 14:10

cletisgipson


1 Answers

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>
like image 161
BSB Avatar answered Oct 23 '25 09:10

BSB