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

Alexander Kandzior alex at opencms.org
Thu Oct 21 09:03:04 CEST 2004


I assume you use OpenCms 5.0.x.

The degradation you observe in OpenCms 5.0.x AFAIK occurs most visible in
the Workplace. The issue is that the Folder tree on the left in the Explorer
view is always loaded _fully_ if any change in the VFS is made. Even locking
is considered a change. If the tree gets very large, loading takes very
long, and the Workplace becomes very sluggish during loading. This also
places a heavy load on the server since it re-loads the tree every time from
the DB and does a full permission check etc. Depending on your hardware, you
will see this degradation if 5000 resources or so are in the VFS.

This issue is fixed in OpenCms 6.0. Now the tree only loads the visible
parts and grows dynamically on the client side.

Best Regards,
Alex.

Alexander Kandzior
Alkacon Software - The OpenCms Experts
http://www.alkacon.com

 

> -----Original Message-----
> From: opencms-dev-bounces at opencms.org 
> [mailto:opencms-dev-bounces at opencms.org] On Behalf Of 
> mmihaili at csc.com.au
> Sent: Thursday, October 21, 2004 1:37 AM
> To: The OpenCms mailing list
> Subject: Re: AW: [opencms-dev] Performance - uploaded files 
> are in the DB ?
> 
> 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
> 




More information about the opencms-dev mailing list