10 Oct
2014
10 Oct
'14
9:10 p.m.
On 10 October 2014 14:59, Mark Rogers mark@quarella.co.uk wrote:
Also: In systems that are designed to store key/value pairs, what's the best way to store historic data?
Generally it depends on: - what are the natural keys for your data (you may have a key with two or three components)? - how you are going to access the data (if you're always searching for time stamp, it might make sense to include this in the key)? - whether the system that you're using supports indexing / value extraction, or some other mechanism that avoids searching through the whole store to find a particular value ("full table scan").