aboutsummaryrefslogtreecommitdiff
path: root/setup
diff options
context:
space:
mode:
authorsoshial <soshial@gmail.com>2021-09-12 05:23:12 +0200
committersoshial <soshial@gmail.com>2021-09-12 05:23:12 +0200
commitd9ad81991da306dcae35bb6b7ba7f90c6d6b8725 (patch)
tree62a61eef60ef195479e6aa297e016b3c055bb26c /setup
parent2a5bf04563ecc8b09f07a0007335bbd111f9c0a2 (diff)
downloadtrackermap-server-d9ad81991da306dcae35bb6b7ba7f90c6d6b8725.tar.gz
trackermap-server-d9ad81991da306dcae35bb6b7ba7f90c6d6b8725.tar.bz2
trackermap-server-d9ad81991da306dcae35bb6b7ba7f90c6d6b8725.zip
filtering optimizations
Diffstat (limited to 'setup')
-rw-r--r--setup/default.xml4
1 files changed, 2 insertions, 2 deletions
diff --git a/setup/default.xml b/setup/default.xml
index e798fcf88..54677d845 100644
--- a/setup/default.xml
+++ b/setup/default.xml
@@ -54,11 +54,11 @@
</entry>
<entry key='database.selectPrevPosition'>
- SELECT * FROM tc_positions WHERE deviceId = :deviceId AND NOT fixTime lt :time LIMIT 1 ORDER BY fixTime DESC
+ SELECT * FROM tc_positions WHERE deviceId = :deviceId AND fixTime lte :time ORDER BY fixTime DESC LIMIT 1
</entry>
<entry key='database.selectNextPosition'>
- SELECT * FROM tc_positions WHERE deviceId = :deviceId AND fixTime gt :time LIMIT 1 ORDER BY fixTime ASC
+ SELECT * FROM tc_positions WHERE deviceId = :deviceId AND fixTime gt :time ORDER BY fixTime ASC LIMIT 1
</entry>
<entry key='database.selectLatestPositions'>