slow to add devices
I don't see any delays on any of our servers. I haven't heard this problem either, so I suspect there's something wrong on your end.
Could I send you an email to support with a username and the link so you can view it? I'll start debugging as well.
If you're interested in paid support - yes, feel free to email.
I identified a performance issue in the Traccar database related to the automatic cleanup process for old position records executed through the following query:
DELETE FROM tc_positions
WHERE fixTime < DATE(DATE_ADD(NOW(), INTERVAL -7 DAY))
The tc_positions table contained more than 22 million records, and the fixtime column did not have a dedicated index. Because of this, the cleanup process was performing full table scans, generating delays and impacting the overall platform performance.
To resolve the issue, I created a dedicated index on the fixtime column in MySQL using the following command:
CREATE INDEX idx_fixtime_only
ON tc_positions (fixtime);
After applying the index, the cleanup process started using optimized range scans instead of full table scans, significantly improving the overall responsiveness and performance of the platform.
Thank you very much Anton for your prompt response.
You should read this:
When adding a new device, it takes a very long time (25 seconds). This didn't happen before. I updated to version 6.13.3, but it's still slow. Any ideas if I need to make any additional adjustments to improve this?