Redis - How to load multiple rows with the same key into Redis?

Question

What is the best approach to load CSV with example:

id1,mike,123 id1,joe,234 id2,ben,235 id2,jack,445

The need is to query based on a first column (key) but there are keys that are repeating...

jjacobi · Accepted Answer · 2022-08-24 21:54:11Z

1

I recommend you to use HASHES because you're trying to do an object representation. According to best practices, you should use it every time it is possible; the key would be your first column and the value would be the repeating lines.

If you want more information about Redis data types, you can go on: https://redis.io/topics/data-types

Also this link is very useful for optimizing Redis: https://redis.io/topics/memory-optimization

From the memory optimization page:

Use hashes when possible

Small hashes are encoded in a very small space, so you should try representing your data using hashes every time it is possible

edited Aug 24, 2022 at 21:54

answered Jan 15, 2019 at 23:44

jjacobi

4054 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Redis - How to load multiple rows with the same key into Redis?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related