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

Joe Desbonnet jdesbonnet at gmail.com
Wed Jun 28 15:07:08 CEST 2006


It's my understanding that hits from Flexcache are served from memory
with zero DB activity.
What is your template's cache property exactly?

On my templates I have
"uri;element;params=(print,accessible);timeout=60" on the template
JSP.

BTW: on a related topic: has anyone tried the Cache option in Apache's
mod_proxy? I wonder what are the pros/cons of caching at the Apache
end vs Flexcache. Any comments?

Joe.

On 6/28/06, m.lambin at crelan.be <m.lambin at crelan.be> wrote:
>
> We use Opencms for an intranet site of 10000 pages. We think that 100
> concurrent users should use the site. We configured the flexcache
> properties on the template files. We made stress test with JMeter. The
> response time and the success rate are not good. We use an Oracle database
> and try with a MySql too. The results remain the same. It's impossible for
> about 20 concurrent users to get a good response time.
> We find that Opencms make about 60 Queries for each page with the
> templateone. With an empty template, opencms make 8 queries in the
> database.
> For the same page, opencms make these queries for every call, why doesn't
> opencms use the cache?
>
> Opencms make an access to the DB to get the language, one for the charset
> encoding, ...
> Is there a solution to prevent that?
>
>
> Thanks in advance..
>
>
>
>
> 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.
>
>
> _______________________________________________
> 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
>



More information about the opencms-dev mailing list