[HN Gopher] How Databases handle 10M devices in high-cardinality...
       ___________________________________________________________________
        
       How Databases handle 10M devices in high-cardinality benchmarks
        
       Author : elorant
       Score  : 27 points
       Date   : 2021-07-03 20:07 UTC (2 hours ago)
        
 (HTM) web link (questdb.io)
 (TXT) w3m dump (questdb.io)
        
       | trollied wrote:
       | This article is nonsense. The whole premise is based on a badly
       | designed schema.
        
       | jeffbee wrote:
       | It seems to me like an anti-pattern to have a time series where
       | the identity is formed by (device,location, _firmware version_
       | ,sensor). It seems to me like (device,location,sensor) is fine
       | identity for an original of, presumably, real-valued time series
       | data, while (device,location,firmware) is a good identity for, I
       | guess, a string-valued time series, and if you really needed to
       | get sensor data aggregated by firmware version you'd do a join in
       | this rare and in my opinion highly contrived case.
        
         | Something1234 wrote:
         | Maybe you want to be able to detect data errors when updating
         | firmware versions? But there should be a way to compute
         | firmware version of a device with some kind of join, maybe
         | device updates?
        
       ___________________________________________________________________
       (page generated 2021-07-03 23:01 UTC)