Page 1 of 1

Putting SQLite in memory on load and periodically saving to disk

Posted: Mon Mar 19, 2018 6:57 pm
by testthevrs
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!