It is normal that there should be some queries for the activity macro. The results are real time. The caching is for reading detailed document information. It's surprising that you are getting queries for a normal view of a page particularly with all panels removed.
What queries do you get in the mysql log on the activity stream with ?xpage=contentview Ludovic 2011/11/5 Yang Li <yang.lee.c...@gmail.com> > Wait! > I tried a simple page with ?xpage=contentview in the URL just now with no > more queries. However, when I tried my profile page with ?xpage=contentview > in the URL, there are still many mysql queries and took a long time! It > seems that the store.cache works for other pages without activity macro but > not pages with activity macro... > > > 于 2011/11/5 13:56, Ludovic Dubost 写道: > >> I'm a bit confused. Is it the same install as Yang Li or a different one ? >> >> >> Are you seeing the queries in the mysql log when you reload a simple page >> or a page with ?xpage=contentview in the URL ? >> >> Ludovic >> >> 2011/11/4 Roman >> Muntyanu<rmuntyan@**softserveinc.com<rmunt...@softserveinc.com> >> > >> >> Thanks. Example here >>> http://www.ow2.org/view/Admin/**CheckIndexes?viewer=code<http://www.ow2.org/view/Admin/CheckIndexes?viewer=code>shows >>> places >>> requiring change (for those who might need it someday) >>> >>> After updating the check index page it now says >>> * Indexes created for wiki xwiki_utf8_innodb >>> >>> Request to Main.WebHome still takes 24 seconds for admin account. >>> >>> -----Original Message----- >>> From: users-boun...@xwiki.org >>> [mailto:users-bounces@xwiki.**org<users-boun...@xwiki.org>] >>> On Behalf >>> Of Ludovic Dubost >>> Sent: Friday, November 04, 2011 23:14 PM >>> To: XWiki Users >>> Cc: users@xwiki.org >>> Subject: Re: [xwiki-users] Activity performance is slow >>> >>> Cache is enabled by default. It's not ehcache but JBoss cache >>> >>> This is probably because you don't have indexes. The Script has 3 >>> occurrences ok 'xwiki' which you should change to your db name >>> >>> Envoyé de mon iPhone >>> >>> Le 4 nov. 2011 à 21:18, >>> coldserenity<rmuntyan@**softserveinc.com<rmunt...@softserveinc.com>> >>> a écrit : >>> >>> Ludovic, thanks for the handy tips, but ... I need some more :) >>>> >>>> I have installed the Admin Tool and it mentioned that indexes were not >>>> created. >>>> So before creating indexes I have decided to upgrade table engine from >>>> MyIsam to InnoDB as Sergiu has suggested in this post >>>> http://xwiki.475771.n2.nabble.**com/Upgrade-to-3-2-minor-** >>>> issues-td688396<http://xwiki.475771.n2.nabble.com/Upgrade-to-3-2-minor-issues-td688396> >>>> 5.html After the change the overall time to load main XWiki page as >>>> administrator has gone from 5 to 25 seconds. My wiki currently is 1100 >>>> documents in count and 400M in size. >>>> >>>> Quick questions: >>>> * is caching enabled by default? >>>> * is caching limiting done simply by document count or by allocated >>>> memory (as most recent EHCache allows)? >>>> >>>> After the upgrade, I receive following error on "XWiki Database >>>> Indexes Check" page >>>> * Failed to check indexes for wiki xwiki: Table >>>> 'xwiki.xwikiattrecyclebin' doesn't exist I think this is related to >>>> fact that my database name is "xwiki_utf8_innodb" >>>> and not "xwiki", because I receive similar results on "MySQL Encoding >>>> >>> Check" >>> >>>> page >>>> * Failed to check xwikidoc encoding for wiki xwiki: Unknown database >>>> 'xwiki' >>>> * Failed to check xwikidoc encoding or collation for wiki xwiki: >>>> Table 'xwiki.xwikidoc' doesn't exist but I don't know where to change >>>> that parameter to proper value - velocity scripts are overcrowded with >>>> 'xwiki' strings. >>>> >>>> >>>> >>>> -- >>>> View this message in context: >>>> http://xwiki.475771.n2.nabble.**com/Activity-performance-is-** >>>> slow-tp69618<http://xwiki.475771.n2.nabble.com/Activity-performance-is-slow-tp69618> >>>> 05p6964056.html Sent from the XWiki- Users mailing list archive at >>>> Nabble.com. >>>> ______________________________**_________________ >>>> users mailing list >>>> users@xwiki.org >>>> http://lists.xwiki.org/**mailman/listinfo/users<http://lists.xwiki.org/mailman/listinfo/users> >>>> >>> ______________________________**_________________ >>> users mailing list >>> users@xwiki.org >>> http://lists.xwiki.org/**mailman/listinfo/users<http://lists.xwiki.org/mailman/listinfo/users> >>> ______________________________**_________________ >>> users mailing list >>> users@xwiki.org >>> http://lists.xwiki.org/**mailman/listinfo/users<http://lists.xwiki.org/mailman/listinfo/users> >>> >>> >> >> > ______________________________**_________________ > users mailing list > users@xwiki.org > http://lists.xwiki.org/**mailman/listinfo/users<http://lists.xwiki.org/mailman/listinfo/users> > -- Ludovic Dubost Founder and CEO Blog: http://blog.ludovic.org/ XWiki: http://www.xwiki.com Skype: ldubost GTalk: ldubost _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
