Hi Paul, On Jan 4, 2009, at 8:18 PM, Paul Armstrong wrote:
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: http://maven.xwiki.org/snapshots/com/xpn/xwiki/platform/applications/xwiki-a... Thanks -Vincent http://xwiki.com http://massol.net http://xwiki.org