Reports perfomance

diagnoz3 months 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 Tananaev3 months ago

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

diagnoz3 months ago
  1. Version 6.3
  2. Stadart clean installed instance
diagnoz3 months ago

3.1 In database I have 347692 records for all devices.

Anton Tananaev3 months ago

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