[opencms-dev] Bad performances problem with queries in the database

[m.lambin at crelan.be]

We tried the performances testing with an apache, but the remains the same.

For the maximum cache size, for these tests it's not the problem, we see
that it's never full because we use a few pages.
We don't know how the flexcache works.

We don't know why nobody has this problem...






                                                                           
             "Joe Desbonnet"                                               
             <jdesbonnet at gmail                                             
             .com>                                                      To 
             Sent by:                  "The OpenCms mailing list"          
             opencms-dev-bounc         <opencms-dev at opencms.org>           
             es at opencms.org                                             cc 
                                                                           
                                                                   Subject 
             29/06/2006 15:55          Re: [opencms-dev] Bad performances  
                                       problem with queries in the         
                                       database                            
             Please respond to                                             
              joe at galway.net;                                              
             Please respond to                                             
                The OpenCms                                                
               mailing list                                                
             <opencms-dev at open                                             
                 cms.org>                                                  
                                                                           
                                                                           




Ideally flex cache should configurable to use a disk cache instead of
memory. In modern operating systems disk access is cached in spare
memory anyway.

As I mentioned in a previous post Apache can be configured to use a
memory or disk cache in mod_proxy, but I have no idea how well that
works with OpenCms.

Joe.


On 6/29/06, François-Léonard Gilbert <gilbertf at gmail.com> wrote:
> Hmmm...   I am not yet familiar with Flexcache operation, but isn't 8 Mb
a
> little short for a 10 000 page website?  What is the average size of your
> pages?
>
>  The pros may have a different opinion, but 800 Mb max size may be more
> appropriate, with an average of 300 Mb.  Of course, if all that cache
space
> gets shoved in the swap drive of the OpenCms server, you will have a
> performance hit, but less than from the avalanche of connections on the
DB
> server...
>
>  YMMV,
>  François-Léonard Gilbert
>
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please
visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev
>
>

_______________________________________________
This mail is sent to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://lists.opencms.org/mailman/listinfo/opencms-dev




This email and any attached files are confidential and may be legally privileged.If you are not the intended recipient, any disclosure, reproduction, copying, distribution, or other dissemination or use of this communication is strictly prohibited.  If you have received this transmission in error please notify the sender immediately and then delete this email.Email transmission cannot be guaranteed to be secure or error free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses.  The sender therefore is in no way liable for any errors or omissions in the content of this message, which may arise as a result of email transmission. If verification is required, please request a hard copy.
Please bear in mind that the content of any email leaving and entering the recipient network 
will be verified against viruses, spam and unsuitable content in accordance with the recipient 
policies and regulations.  Halted messages will therefore be destroyed without any further 
notice.