Re: Storing blobs in database vs filesystem

Jared Said: Reduce licensing costs? How is that?

Obviously depends on the architecture, so that is why I said "opportunity". If the blobs are stored in Oracle, then you must license Oracle on a server large enough to serve the entire application. If the Java application executes on the application server and the database only stores the path to the graphic object and other information about the object, then you have the opportunity to put the big files on a separate fileserver, and tune it for serving the files. I haven't tried this, but it seems like it should work.

Dennis Williams

--
http://www.freelists.org/webpage/oracle-l