Reports perfomance

diagnoz a year ago

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/

Anton Tananaev a year ago

What version of Traccar are you using? Do you have any changes in the reports config?

diagnoz a year ago
  1. Version 6.3
  2. Stadart clean installed instance
diagnoz a year ago

3.1 In database I have 347692 records for all devices.

Anton Tananaev a year ago

Check the query that's executed when you do the report. Then see why it takes so long.