in reply to Re^3: Perl solution for storage of large number of small files in thread 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..)
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] |
|