Hello, Im coming to an end with my database software. I filled the database with around 150 rows, but now I got the problem that performance is really trash with everything it does, even if it only does single row querys. So I thought maybe it´s possible to create a cache which stores all data once they are loaded which then is being used by all the other methods making a query.
This is the code where all aircrafts are being collected, at the moment the data is loaded asynchron to not block the UI.
How can I build such a cache with is used by every method?