API Rest timeout

Hello everyone, I'm facing a problem I don't know how to solve: I have a client with more than 500 devices. When I try to view a report, for example, the summary report for all 500 devices for a month, the API response hangs and a timeout error appears. I have a server with 128GB of RAM and an NMVe disk. Where can I fix this problem? On the machine itself? In a Traccar configuration? In MySQL?

I appreciate any feedback, as it will be very helpful.

Anton Tananaev12 days ago

What Traccar version? Are you doing Excel report?

Hi Anton, I'm using Traccar 5.0 for several technical reasons. Since I've made some modifications, it's difficult for me to upgrade for now. Regarding Excel reports, no, I don't use Excel reports; I'm just using the Reports/Summary API to generate them.

Anton Tananaev12 days ago

The version would explain it. In newer versions of Traccar we have fast reports option that probably wasn't available in 5.0.

A couple of months ago I tried to update to the latest version of Traccar, but for some strange reason the insertion into the positions table was quite delayed, for example, while in Traccar 5.0 it inserted about 50 positions per second, in the latest version it only inserted about 5 or 6 positions per second, obviously I must have done something wrong when updating but I didn't know what my mistake was, so I decided to leave it again in Traccar 5.0

Anton Tananaev11 days ago

We have some clients on the latest version with about 100 locations per second. No issues with much lower server specs.

Thanks Anton, I'll try to update to the latest version.