best way to archive / delete positions and log

Hello,

I use Traccar with around 250 devices and my database enlarge quickly

My device insert around 10000 positions by day.

What is the best way to archive or delete positions and log automaticly ?

For your information i use mysql

Thanks

There is a configuration parameter for removing old data. Alternatively you have some external script to archive/remove old data.

ok thanks

can you tell me what is the parameter and where can i found external scripts

Please read official documentation.

As for external script, you would have to write it yourself or find somewhere.

ok i search in documentation

i can delete directly in database ? ex : delete from positions where ....

I don't see why not. Just make sure you don't delete positions that are referenced from the devices table.