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: users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] On Behalf Of
bjquinn
Sent: Friday, November 16, 2007 9:14 PM
To: users(a)xwiki.org
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
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users