What's the best way to do listing with searching, sorting and pagination with redis and nodejs?

Question

I have a list of contacts where I am fetching millions of data and showing in a list with pagination, keyword search and column sorting option. I want to implement redis over here to serve the result faster.

My question is what's the best way to use redis in the above mentioned scenario? Also if redis does not fit over here then suggest me some alternative solution which can be fit over here to server my purpose. I am working in nodejs serverless stack.

score 4 · Accepted Answer · answered Jan 05 '22 at 16:27

4

RediSearch module seems like the perfect fit here.

FT.SEARCH users "@last_name:jones" SORTBY first_name DESC LIMIT 0 10

Here you are filtering on the last_name, sorting by the first_name and paginating, displaying 10 results, starting from the first one (zero-based)

answered Jan 05 '22 at 16:27

Anton

3,587
2
12
27

Consider using TAG fields for first_name and last_name instead of TEXT fields. – Ariel Jan 06 '22 at 10:34

What's the best way to do listing with searching, sorting and pagination with redis and nodejs?

1 Answers1