DHS connect to remote sql database?
Would it be theoretically possible for DHS to connect to a remote SQL database? I'm just thinking of ways to possibly offload the memory usage out of my server cloud instance since memory is a little bit limited. Any any implications of doing such a feature?
6 Replies
DHS can run on a server that has less than 1 GB of memory, so I don't think that would be my motivation for implementing it. But a "real" database would probably be able to both read and write data faster
oh i was thinking more on the lines of a +5GB database taking up space as such, unless if there's something I'm not understanding 😅
The database is not all loaded into memory at once :)
And the storage cost will be roughly the same no matter where you store it; be it a SQLite file or a MySQL server
ah, I think i understand which pages we're on, im moreso referring to the fact that my instance needs enough space for the dhs sqlite file + server size in general + temporary files for backing up
currently it looks like (respectively) 5.2 GB + 11 GB + 1.8 GB = 18 GB of 24 GB total
before my DHS sqlite file hit 11 GB on my test server, which would've made using the production server not viable, but thankfully i was able to decrease it to 5.2 GB after doing a proper pregen. I just hope that the sqlite file won't inflate by another 6GB, otherwise ill reach that 24GB limit. hope this makes sense!
but yes, i understand that in memory, it won't load in all 5.2 GB worth of data 🙂
It would be great if the distant horizon data could be stored on a MySQL server. My hosting provider offers me plenty of storage, but they also offer independent MySQL storage. It would be nice to store the distant horizon data in MySQL and leave the main server free.
yeah exactly ^ def more of a quality of life improvement though, but it would definitely solidify my indefinite usage of DHS 🙂