Im working on project on my work where i have implemented an sliding window over time to do inferance.
The problem that i have is that it is shifting through time.

Algorithm is something like this.
Determine time
Query table based on time
Get elements
Check if elements are correct
Put elements in json
Put json message in queue
Calc time how long it take and sleep till windowSize.

I see we have problems with that the loop that does all these steps is not 100% on time.
But i try to account for that that to – from the sleep.
But still i see that it moves through time and that when i have hard reset it will rest back.

Did alot of tests and worked on making drawings and calculations