This PR adds an index to the detections table. We tested this on live data from the 6urenloop event and got a speedup from +-600ms for a request to +-60ms for the same query.
This pr also removes the fixes a n query problem.
Fetching 1000 detections will no longer result in 1003 queries. This has been reduced to 4.
This PR adds an index to the detections table. We tested this on live data from the 6urenloop event and got a speedup from +-600ms for a request to +-60ms for the same query.
This pr also removes the fixes a n query problem. Fetching 1000 detections will no longer result in 1003 queries. This has been reduced to 4.
:rocket: