Forum OpenACS Q&A: Response to to blob or not to blob

Collapse
Posted by Janine Ohmer on
On the other hand, there's no doubt that any site that does a high volume of file upload/downloads will want an in-filesystem strategy, due to the much higher efficiency of that approach.

Seeing as it's a year later and we now have Oracle in the mix, is this still true? Has anyone done any benchmarking of the two approaches?

I want to know because we have a client with a 12 Gb (and growing) Oracle database that consists mostly of uploaded files. I'm trying to talk them into moving them into the filesystem, mainly to make backing it up easier but if it will be faster too, so much the better!