aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAnton Tananaev <anton.tananaev@gmail.com>2017-04-15 16:15:25 +1200
committerAnton Tananaev <anton.tananaev@gmail.com>2017-04-15 16:15:25 +1200
commitdb86eb01e0e82fe79343b3e86d4605509ba8ad1b (patch)
tree7e57f828ff7391584e916d18cb91e7212a898162
parent8dc80b64ea0445b9d2ed7e19e8934900a13e5b07 (diff)
downloadtraccar-server-db86eb01e0e82fe79343b3e86d4605509ba8ad1b.tar.gz
traccar-server-db86eb01e0e82fe79343b3e86d4605509ba8ad1b.tar.bz2
traccar-server-db86eb01e0e82fe79343b3e86d4605509ba8ad1b.zip
Optimize latest position select query
-rw-r--r--setup/default.xml2
1 files changed, 1 insertions, 1 deletions
diff --git a/setup/default.xml b/setup/default.xml
index e251fbeee..971d923a8 100644
--- a/setup/default.xml
+++ b/setup/default.xml
@@ -190,7 +190,7 @@
</entry>
<entry key='database.selectLatestPositions'>
- SELECT * FROM positions WHERE id IN (SELECT positionId FROM devices)
+ SELECT positions.* FROM positions INNER JOIN devices ON positions.id = devices.positionid;
</entry>
<entry key='database.updateLatestPosition'>