Putting SQLite in memory on load and periodically saving to disk

The "to-do" list for Virtual Radar Server is as long as my arm, but if you want to pile more work onto it then this is for you.
Post Reply
testthevrs
Posts: 3
Joined: Fri Dec 01, 2017 4:05 pm

Putting SQLite in memory on load and periodically saving to disk

Post by testthevrs » Mon Mar 19, 2018 6:57 pm

http://www.sqlite.org/backup.html
https://www.sqlite.org/inmemorydb.html

VRS seems to grind to a halt under many load requests or spikes in requests.

How is the SQL database and aircraft.json look up done? Are we querying disk i/o or using some sort of caching to server requests.

Exmaple, how is the geo-box request done?

Ever think of using Redis, memcache, SQLite or any of the in memory cache inside VRS?

Any insight is appreciated!

Post Reply