One more upside is that with filesystem attachments you can easily use streams and never hold whole attachment in memory. This is really necessary for scalable deployment.
And BTW there is no max_packet_size restriction as well. One can also do streaming with db BLOBs, but not via hibernate I believe. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of bjquinn Sent: Friday, November 16, 2007 9:14 PM To: [email protected] Subject: Re: [xwiki-users] Xwiki file and attachment storage vmassol wrote: > > However I'm curious to know why you need attachments stored in the > file system. > Because many of these attachments may be large (>50MB), and over time the database can grow to be unweildy. Currently that's our problem with our exchange server setup (people keep emailing these files back and forth as it stands now *shudder*). The upside of storing attachments in a filesystem is easier access from other clients (as the other poster suggested), less likelihood of corruption on large databases (our Exchange DB is 200+ GB right now), less likelihood of backup problems, copy-only-what's-changed backups, and quicker backup and restore time. -- View this message in context: http://www.nabble.com/Xwiki-file-and-attachment-storage-tf4214945.html#a1379 9175 Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
