Forum Discussion

DoctorYSG's avatar
DoctorYSG
Helper III
2 years ago
Solved

Feature request: Format for TimeStamps in Storage Engine (Double?)

From what I have read, the PBI Storage engine represents TimeStamp values as a Double. Which means that it does not do any optimized storage (RLE, HashTable, value compression). 

We are creating fairly large FactTables, that are index'ed by a Timestamp (We do IOT work, and this is network telementry that has a timestamp and a few other values). 

We don't need granularity more than an hour, but by my calculations, even if you go into Seconds since 1900, there is plenty room in a 64 bit integer to store all the days. 

No, we don't want to create our own version of TimeStamp. Sounds like a simple feature to test if the value is aligned to a minute or a second, the storage engine could optimize the storage for the value using an 64bit integer.


This is a feature request. Is this a good place to add it?