My main usage in the DB is to store and use geo-spatial data. When I move (and therefore have new coordinates) I would like the DB to “know” that it should move its focal point with me. Since I’m using an embedded system with limited resources (RAM) I need the DB to “know” which data to fetch from its local FS (file system) so when I perform a query (e.g. $geoWithin) the most relevant data will be accessable in minimum time. I need to configure the local database server to know to have the relevant data in RAM and update itself in accordance with my geo-position changes (my queries will reflect my position).
Is that possible?
if so, please guide me to the solution.