in reply to Re^2: Perl solution for storage of large number of small files
in thread Perl solution for storage of large number of small files
So, do you actually recommend sqlite as storage for binary data?
Well, I don't recommend neither disrecommend it. I was only suggesting you should try another backend!
Which database is the best for a given problem, does not depend exclusively on the data structures but also on the usage pattern.
Anyway, if you need to access 2GB of data randomly, there is probably nothing you can do to stop disk trashing other than adding more RAM to your machine, so that all the disk sectors used for the database remain cached.
In Section
Seekers of Perl Wisdom