<Regenaxer>
PicoLisp uses normal files for blobs as you know, but I never felt they are too slow
<Regenaxer>
What SQLite does seems more like +Swap in PicoLisp
<Regenaxer>
there we have also no separate open/close
<beneroth>
ah, maybe it is mainly about non-linux-OSes
<beneroth>
HN comment says "It gets weird when you throw Linux in the mix - open/close are extremely cheap on Linux, to the point of being free - at least used to be before Spectre and Meltdown and what not. So on Linux doing n more open/closes isn't much different than doing a single pair if n is not humongous and the program is doing other things besides just open close."
<Regenaxer>
ok, but of course open/close still have some oherhead (very small considering the overhead of blobs in general)
<Regenaxer>
Yeah
<beneroth>
T
<beneroth>
what to take from this: small files (below FS block size, so below 4kb? usually) might make sense to store within db as value, not as +Blob
<beneroth>
tighter packaging.
<beneroth>
of course the access patterns come then into the mix...
<Regenaxer>
I dont think I would recommend that
<beneroth>
T
<beneroth>
not worth on Linux.
<Regenaxer>
yeah
<Regenaxer>
And inconvenient
<beneroth>
and pilDB Blob handling is excellent
<Regenaxer>
as blobs have files usually
<Regenaxer>
binary files, not exactly of block size
<beneroth>
good point though: OS fs I/O of course also includes file permission checks, and those are much more complicated on Windows than UNIX with the bit-scheme
<Regenaxer>
And they are passed somewhere else as a whole
<beneroth>
fully agree
<beneroth>
here another comment about per-user-dbs, same as you did recently :)