Reports perfomance

diagnoz4 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 Tananaev4 months ago

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

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

3.1 In database I have 347692 records for all devices.

Anton Tananaev4 months ago

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