AW: [opencms-dev] Performance - uploaded files are in the DB ?

Thu Oct 21 01:36:32 CEST 2004

Rafal,

We have noticed dramatic degradation in performance after uploading lots of
data (like word documents, excel, various other types of reports) into
OpenCMS.
There could be many reasons for this, not just OpenCMS. There were
suggestions to remove these reports (resource types) out of OpenCMS and be
served by some other server/app and manually link to them. But this would
draw alot away from using OpenCMS in the first place.
We have decided not to commit any time on investigating these issues on the
current versions of OpenCMS, but rather on the latest (one basic feature we
see may be helpful is the ability to remove history files).
We are currently in the process of migrating one of the worst websites to
version 6, and monitor the performance.
I will endeavour to release any significant results to the community (if
allowed :))

Moris Mihailidis
__________________________________________________
Computer Sciences Corporation
EBS-BSS Web Services e-Business South
58 Queensbridge St, Southbank, VIC 3006, Australia
Ph: +61-3-8695-1527    Fax:+61-3-8695-1540
Email: mmihaili at csc.com.au
----------------------------------------------------------------------------------------

This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. NOTE: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit written
agreement or government initiative expressly permitting the use of e-mail
for such purpose.
----------------------------------------------------------------------------------------

                      Tristan Tarrant                                                                                                      
                      <ttarrant at etnoteam.i         To:      OpenCMS <opencms-dev at opencms.org>                                              
                      t>                           cc:                                                                                     
                      Sent by:                     Subject: Re: AW: [opencms-dev] Performance - uploaded files are in the DB ?             
                      opencms-dev-bounces@                                                                                                 
                      opencms.org                                                                                                          

                      20/10/2004 06:42 PM                                                                                                  
                      Please respond to                                                                                                    
                      The OpenCms mailing                                                                                                  
                      list                                                                                                                 

On Wed, 2004-10-20 at 10:18 +0200, Rafal Markut wrote:

Hello,> > I see that when I upload a binary file then it's saved in the
DB.> > What happened when I have many MBs GBs of data? what about
theperformance ?>> OpenCMS (especially v6.0 with its on-demand export) will
put binaryfiles on the file-system (images, pdfs, movies).> You can also
explicitly use the static export feature.But I don't want to export them. I
want to keep them in the system (e.g.to display them)

When I say "static export" I mean the same thing that OpenCMS does: the
files exist both on the database and under a user-defined export directory
(usually opencms/export) so that they are delivered directly by the
application server/web server without going through the opencms servlet.

Tristan
(See attached file: smime.p7s)

_______________________________________________
This mail is send to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://mail.opencms.org/mailman/listinfo/opencms-dev
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/octet-stream
Size: 2121 bytes
Desc: not available
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20041021/00ca3a0b/attachment.obj>