Mass query last position

GIS-FACTORY7 months ago

Hello, we thank you in advance for your help and guidance in each of our queries.

Currently one of our clients requires running a massive query of the last location of more than a thousand devices in short periods of time.

We are currently running the Traccar API, which works perfectly, but its response time exceeds the times required by the client, in addition to significantly increasing server consumption. Therefore, we need to know where I can see or find the query or table where it is stored. the last location or locations, if not separated. please.

Anton Tananaev7 months ago

Last position id is stored in the devices table.