how to get a member with maximum (or minimum ) score from redis sorted set given a subset of members?

redis sortedset
KCore picture KCore · Nov 16, 2013 · Viewed 12.4k times · Source

I am writing a algo for deducing the user with the least amount of work load. Based on the type/complexity of the tasks being created, i narrow down on the list of the users that are capable of performing it. Now, I need to find the user who has the least number tasks currently assigned to him/her. I am using redis sorted set to store the members/users along the score indicating the number of the tasks assigned to them. Is there a way to get a member with least score given a subset of members?

Answer

Mirek Rusin picture Mirek Rusin · Feb 26, 2014

Member with minimum score:

ZRANGEBYSCORE myset -inf +inf WITHSCORES LIMIT 0 1

Member with maximum score:

ZREVRANGEBYSCORE myset +inf -inf WITHSCORES LIMIT 0 1

Related questions

how to get data based on date range in redis

I have a log data in mysql id | value | date 1 | 10.2 | 2017-07-20 18:00:00 2 | 10.5 | 2017-07-20 18:00:01 3 | 10.3 | 2017-07-20 18:00:03 then transformed it into hash dan sorted set in redis. This is my hashes: hmset mylog:1 id 1 value 10.2 date 1388534400 hmset mylog:2 id 2 value 10.5 date 1388534401 …

Read More
Redis: Sum of SCORES in Sorted Set

What's the best way to get the sum of SCORES in a Redis sorted set?

Read More
How do I run Redis on Windows?

How do I run Redis on Windows? The Redis download page just seems to offer *nix options. Can I run Redis natively on Windows?

Read More