I have MySQL table elements_info with fields:
element_id | price | time_start | time and
To get element_id and price fields from MySQL i use query:
SELECT * FROM `elements_info` WHERE 1447141365 BETWEEN time_start AND time_end;
Where 1447141365 - current timestamp.
Can I store this structure in Redis (maybe zset)? Or maybe I should choose another NoSQL DB to get elements by time range?