At 2009-01-04T20:08+0100, Vincent Massol wrote:
On Jan 4, 2009, at 5:49 PM, Elek Márton wrote:
Is it normal that the blog listing page
(
http://localhost:8080/xwiki/bin/view/Blog) is generated in 6-10
seconds if I have only one word per title/content and in 25-30
seconds
if I am using some more detailed articles?
I am using XWiki 1.7 with 1.0 XWiki syntax + Mysql (with indexes).
Is there any solution to achieve faster performance?
Performance should be sub-second (a few ms) especially when executed
locally so you have a problem somewhere.
As per this bug, this is a known problem:
http://jira.xwiki.org/jira/browse/XWIKI-3022
Can you start by verifying if the problem is in
your database, in
your
web server (if you have any) or in XWiki?
Is this a large wiki?
From the bug above:
"""
A load of the front page (which includes the blog on my site) takes
24,452 calls to MySQL with 22,940 calls recorded in the query log
before
the limit statement.
I've got about 800 blog posts on my site so this seems a little
excessive.
During the time when it's doing the heavy querying, one core is
stuck at
100% utilization.
"""
For me, it can take 20-30 seconds to load that page. The workaround
I'm
using is to cache the page, but that's only so effective.
Unfortunately, I've got a lot of things going on so haven't thrown
dtrace at it yet.
If you install XWiki Enterprise you don't get this behavior so there
must be something happening. Do you have a way to reproduce this
starting with a clean install?
Alternatively if you could attach a DB dump that reproduces the pb
maybe someone here could have a look see if it can be reproduced.
Paul, is this caused by the number of blog posts?
Last, we have a new Blog application which is going to be released
real soon now. Would be good if you could try it and see if it helps.
Snapshot here: