It's what I mentioned the other day, is it worth re-looking into this if its so critical to the police?
I notice the length of times for logins stored are pretty high, maybe just restrict it to only the last month of logins or something?
Its very frustrating because I patrolled over 40hours last week on server 1 but there is no way it will be able to be used to show police command how active I am because it isnt logged.
May I ask which part of the system is the bottleneck @Wilco? If it is a problem on the database being queried each time on the backend, why not just cache the results for say 12 hours or use something like Redis on the backend? Or if one wanted to go a little further, let me know how the data is stored and I'll build my own stats system as a prototype so not all the work falls to just you and Ciaran, since this is a relatively simple task to outsource I think.