Please discuss the pros and cons of storing a file and its meta data in the database vs file in the filesystem and the metadata in the database.
File + Metadata in DB 1. Can participate in transaction. 2. Does not get out of sync. 3. Overhead of fetching the file. File in Filesystem and Metadata in DB 1. File and metadata may get out of sync. 2. Less overhead. Any other good points? I am looking especially for pros for File+Metadata in DB... Yeah, not really mysql specific, but I think people may find it interesting anyway. Thanks, Anh _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
