Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Chris Whittle
Document Library Upload Sizes... What does it effect
May 26, 2009 1:21 PM
Answer

Chris Whittle

Rank: Expert

Posts: 462

Join Date: September 17, 2008

Recent Posts

If I change the upload size to be bigger what(if any) ill effects can happen? I have it currently have it changed to 10 megs but have been requested for more... We are using MSSQL to connect to jackrabbit to store our documents....
Richard Sezov
RE: Document Library Upload Sizes... What does it effect
May 26, 2009 1:42 PM
Answer

Richard Sezov

LIFERAY STAFF

Rank: Regular Member

Posts: 210

Join Date: February 7, 2007

Recent Posts

That has to do with what your users are putting into the database. If you change the upload size to 10 MB, that means that users can upload files with a size of up to 10MB. So any single file can be 10MB or smaller. When you change it to something else, you are setting the maximum file size for any particular file uploaded to the Document Library.

Because you are storing these files in your database, effectively, they become BLOBs in your database. So you may want to review your database capacity before deciding to change this setting just to make sure that you won't run out of space in your database for the foreseeable future (and that any backup procedures you have for your database are adequate to store the amount of data you will need to store).

The only other "ill effect" that I can think of is the performance penalty for storing binary files in a database. You generally can get better performance by storing files on the file system. If, however, it is currently performing well enough for your needs, this may not be an issue.

Hope this helps!

--Rich
Chris Whittle
RE: Document Library Upload Sizes... What does it effect
May 27, 2009 5:48 AM
Answer

Chris Whittle

Rank: Expert

Posts: 462

Join Date: September 17, 2008

Recent Posts

thanks Rich,
Yeah we are using a clustered environment so from what I gather storing content in database is what is suggested? Is there any other tweaks that could help performance when storing in a database?