From d9ad81991da306dcae35bb6b7ba7f90c6d6b8725 Mon Sep 17 00:00:00 2001
From: soshial <soshial@gmail.com>
Date: Sun, 12 Sep 2021 05:23:12 +0200
Subject: filtering optimizations

---
 setup/default.xml | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'setup')

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'>
-- 
cgit v1.2.3