diff options
| author | soshial <soshial@gmail.com> | 2021-09-12 05:23:12 +0200 |
|---|---|---|
| committer | soshial <soshial@gmail.com> | 2021-09-12 05:23:12 +0200 |
| commit | d9ad81991da306dcae35bb6b7ba7f90c6d6b8725 (patch) | |
| tree | 62a61eef60ef195479e6aa297e016b3c055bb26c /setup | |
| parent | 2a5bf04563ecc8b09f07a0007335bbd111f9c0a2 (diff) | |
| download | traccar-server-d9ad81991da306dcae35bb6b7ba7f90c6d6b8725.tar.gz traccar-server-d9ad81991da306dcae35bb6b7ba7f90c6d6b8725.tar.bz2 traccar-server-d9ad81991da306dcae35bb6b7ba7f90c6d6b8725.zip | |
filtering optimizations
Diffstat (limited to 'setup')
| -rw-r--r-- | setup/default.xml | 4 |
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'> |