We've had really good success with the accelerated check-ins framework that @obelisk implemented alongside the ad-hoc queries, it's very close to realtime for us which is really nice