3 ms·
Just speculating, but the database is mostly used for the metadata. If implemented well, there will be very little overhead for reading and writing to a file, e
by matharmin 7y ago
Just speculating, but the database is mostly used for the metadata. If implemented well, there will be very little overhead for reading and writing to a file, especially if the size stays constant.
Some databases rely on specific low level file system operations, which may not be optimised in a niche filesystem. But in theory there shouldn't be anything preventing it from being optimized, and the database from running at close to maximum performance.
- amelius 7y agoOk, but if you store only metadata then you lose the advantage of running all the file operations inside a transaction. Then again, posix has no notion of transactions ...
- Someone 7y ago”there will be very little overhead for reading and writing to a file, especially if the size stays constant” Not if you add primary keys, indexes, ‘on update’ clauses, etc.