Separate positions by Device
It might be possible because you can override SQL queries in the config, but don't have an example.
What problem are you trying to solve using separate tables? Performance?
I want to use this function for better performance and for a project that will run on top of traccar via PHP
Why not use standard partitioning for it instead of reinventing your own wheel?
https://dev.mysql.com/doc/refman/8.0/en/partitioning-overview.html
Is it possible to separate the positions by devices in the database?
Example:
Device 1 = Table positions.1
Device 2 = Table positions.2
Device 3 = Table positions.3
And so on
If possible, I could give you an example of configuration