Re^4: Perl solution for storage of large number of small files

Actually, thank you for the lengthy reply!

I already learned about sqlite's async mode, but was too lazy to recompile it and just switched the design to in-memory (sqlite was used only on the index part - I am not such a big fan of binary data in databases yet..)
Pooling updates/writes (as in your transactions hint) was planned to streamline sqlite, but I pulled the plug on this when I opted for the in-memory approach.

Thanks for all your help guys! Until I need to handle more than 25,000,000 files, plain fs will do (without re-inventing the wheel..)

Comment on Re^4: Perl solution for storage of large number of small files

Replies are listed 'Best First'.
Re^5: Perl solution for storage of large number of small files by jbert (Priest) on Apr 30, 2007 at 12:57 UTC
You're very welcome. For completeness, I should mention that modern versions of sqlite can be put into and out of synchronous mode with a pragma, rather than recompilation. (I've been very impressed with sqlite. It has limitations, but the docs are up-front about them, it is so easy to get started with and feels very robust to me.)	[reply]