The big disadvantage is performance. Relational databases do not store or handle big blobs efficiently. With a large enough number of documents and blobs the size of the database with grow to a point where backups and (more importantly) recovery can become a real challenge. In these cases storage of blobs to the file system is the only solution. We use Postgres for our email archiving solution and have to deal with terabytes of data ... we tried the all database route and quickly discounted it when we saw the real-world performance drop like a rock.
I suppose if you only need to store a few blobs it's not a big deal, but if the number and size is more than trivial you might as well start with blobs in the file system. My two cents. Bruce. From: Alexander Litvin <[email protected]> To: [email protected] Date: 10/14/2009 03:09 PM Subject: [Ecm] Is it possible to configure VCS to store files (blobs) in DB? Hello! In this mailing list VCS benefits were discussed some time ago. One of mentioned benefit was: - backups (use the standard solution for your database). I think this benefit is real advantage only if I can use standard solution of my database in order to backup all parts of user documents including file content (blobs). Otherwise I need to backup DB content and files (blobs) separately. Is it possible to configure VCM to store files (blobs) into DB instead of “server/default/data/NXRuntime/binaries/data/” directory in order to have all document information in DB? If so, is there any articles/discussions about “VCS with blobs in server/default/data/NXRuntime/binaries/data/” vs “VCS with blobs in DB” comparison? Best regards, Alexander. _______________________________________________ ECM mailing list [email protected] http://lists.nuxeo.com/mailman/listinfo/ecm To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
_______________________________________________ ECM mailing list [email protected] http://lists.nuxeo.com/mailman/listinfo/ecm To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
