Data Cache Backup

Hi,

This is a great product - well done!

I am using Traccar with SQL Server 2016 and understand that Traccar has an independent cache so I can't update SQL directly I have to go via API which is cool.

This will also mean there is no point in adding indexes to SQL as they won't be used by the front UI however if I wrote my own front end dashboard then I could access SQL direct.

My questions are:

1. Where is the cache saved and do I need to back it up? or if I re-install on a new server and restore a SQL backup will the cache be rebuilt?
2. Is there any plans to read direct from the database instead of internal cache so you can benefit from SQL performance tuning and scaleability?

thanks,

Rob

1. Cache is only in memory. On restart data is read from the database.
2. This question doesn't really make sense. For reports Traccar obviously uses database directly. For live data SQL can't possibly be faster than just keeping data in memory.

I see I misunderstood. I thought you may have been using a file cache.

For performance I should use more RAM and faster speed RAM. Does the system benefit from multiple CPUs does it use multi threading?

Yes, it does use multi-threading. [UPDATED]

Amazing!