Conversation
Notices
-
Embed this notice
MortSinyx (cnx@awkward.place)'s status on Thursday, 16-Jan-2025 19:31:10 JST MortSinyx
Yea indeed it works, but why @xarvos? If the load is so low it's more efficient to attach the DB for each user only when in need (e.g. to minimized memory usage in a shared system), you might as well just use FS as a DB. Otherwise, a Θ(n) number of DB would only lead to worse latency AFAICT.
IIUC the whole point of a DBMS is to optimize FS access, so unless for logical reasons you should have as many SQLite files as the system's number of physical di*ks.