Sample Header Ad - 728x90

How to reduce redundant time-series data in MySQL into a function?

1 vote
1 answer
826 views
i have a question that actually does not fit here very much, but maybe it fits. So, i have data like this: enter image description here How can i reduce this 3 entries with same values? Sure, i can just delete the other 2, but in time-series data i can not just do this, this would hide the information, that in between the real time 15:19:45 and 15:19:55, the value did not change. So i thought about saving the delta-time and value in a separate table and only save the first entry and mark it, but i dont know if this is the best way to do so.
Asked by Rep (11 rep)
Sep 9, 2016, 10:15 PM
Last activity: Jul 8, 2025, 08:01 AM