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-application-blog/1.0-SNAPSHOT/ Thanks -Vincent http://xwiki.com http://massol.net http://xwiki.org _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
