Hello, I have 15 devices and try to execute Trips report.
When i select period to one week i spend 5 minutes to complete a report. This is too much. But in my server a CPU almost free (5% load max). I have SSD and 5Gb memeory.
How I can improve perfomance ?
P.S.
Im using MySql and set recomendations: https://www.traccar.org/mysql-optimization/
What version of Traccar are you using? Do you have any changes in the reports config?
3.1 In database I have 347692 records for all devices.
Check the query that's executed when you do the report. Then see why it takes so long.
Hello, I have 15 devices and try to execute Trips report.
When i select period to one week i spend 5 minutes to complete a report. This is too much. But in my server a CPU almost free (5% load max). I have SSD and 5Gb memeory.
How I can improve perfomance ?
P.S.
Im using MySql and set recomendations: https://www.traccar.org/mysql-optimization/