Vista combinada Visión Plana Vista de árbol
Discusiones [ Anterior | Siguiente ]
toggle
Chris Whittle
Document Library Upload Sizes... What does it effect
26 de mayo de 2009 13:21
Respuesta

Chris Whittle

Ranking: Expert

Mensajes: 462

Fecha de incorporación: 17 de septiembre de 2008

Mensajes recientes

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
26 de mayo de 2009 13:42
Respuesta

Richard Sezov

LIFERAY STAFF

Ranking: Regular Member

Mensajes: 215

Fecha de incorporación: 7 de febrero de 2007

Mensajes recientes

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
27 de mayo de 2009 5:48
Respuesta

Chris Whittle

Ranking: Expert

Mensajes: 462

Fecha de incorporación: 17 de septiembre de 2008

Mensajes recientes

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?