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
I had a stint on this project with sqlite, and although I like databases, I was (so far) under the impression storing binary data into a database is not the best way to go. For me the blob columns always felt like an add-on...
Second, the performance with sqlite (async off) was poor, and it was only munging light text data. This is why I never thought of going completely db with this. And I didn't want to install a full mysql server on the machine, just to find out that it would have the same problems.
I think using the fs is ok for ~20-30 mio. files. So, do you opt for using a db when this number grows?