diff options
| author | Anton Tananaev <anton.tananaev@gmail.com> | 2017-04-15 16:15:25 +1200 |
|---|---|---|
| committer | Anton Tananaev <anton.tananaev@gmail.com> | 2017-04-15 16:15:25 +1200 |
| commit | db86eb01e0e82fe79343b3e86d4605509ba8ad1b (patch) | |
| tree | 7e57f828ff7391584e916d18cb91e7212a898162 | |
| parent | 8dc80b64ea0445b9d2ed7e19e8934900a13e5b07 (diff) | |
| download | traccar-server-db86eb01e0e82fe79343b3e86d4605509ba8ad1b.tar.gz traccar-server-db86eb01e0e82fe79343b3e86d4605509ba8ad1b.tar.bz2 traccar-server-db86eb01e0e82fe79343b3e86d4605509ba8ad1b.zip | |
Optimize latest position select query
| -rw-r--r-- | setup/default.xml | 2 |
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'> |