Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Any serious downside to allowing lots of large file uploads?

  Date: May 29    Category: Sharepoint    Views: 557

I work at a school that uses SharePoint 2007. Each course has a document
library dropbox. The current maximum file upload size limit is around 80mb. I
try to discourage the uploading of large file because over time my database is
growing and growing etc..... These uploads can contain files with embedded
videos, audio pictures etc..... They are class project presentation files from
the students.

Is there any real downside to allowing ongoing large file size uploads? My best
argument against it is the database restore time, if needed. Of coure there are
timeouts and other issues I work through... My sql server is a pretty decent
windows server 2008 r2, 4 cpu, 64bit, lots of ram ans disk space etc...

Are there better alternatives, other than SharePoint? Another item to mention
is that we use a 3rd party product called SharePointBoost. It lets us configure
workflow on the document library such that students don't see each others
uploads. We use this especially for exam uploads. SharePoint Lists already
have this built in, but the document libraries don't....



5 Answers Found

Answer #1    Answered On: May 29    

Yes, SQL will store this items as blobs. They are not easy to optimize in the
DB, if at all. Thereby creating speed and performance issues as well. I
recommend you support large files as it is inevitable from industry standpoint.
And look at blob externalization tools. One I've implemented is metalogix
storagepoint. Works great.

Answer #2    Answered On: May 29    

The downsides are potential performance problems, which can be mitigated; and
database size limitations, which can be monitored and mitigated. (this includes
backup/restore & disaster recovery)

As long as you can maintain your backup times & ability for DR, and your
performance is acceptable because you have the hardware and configuration to
handle the load, then the size of the file upload should not be a major concern.
Large files don't 'break' SharePoint, the lack of proper infrastructure to
handle the large files 'break' SharePoint.

You may want to consider upgrading to 2010 and implementing Remote Blob Storage
to improve performance with those large files. SharePoint 2010 allows for
larger content databases as well, which may be a benefit to you if you allow the
large file uploads & they grow to significant levels.

Answer #3    Answered On: May 29    

Excellent. We are planning to be on 2010 by next Fall.

Answer #4    Answered On: May 29    

The main consideration with using sql's externalization is that you will need
enterprise licenses.

Answer #5    Answered On: May 29    

We do have an enterprise license, so far so good...