Thanks.  Example here 
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-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] On Behalf Of Ludovic Dubost
Sent: Friday, November 04, 2011 23:14 PM
To: XWiki Users
Cc: users(a)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(a)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
 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
 05p6964056.html Sent from the XWiki- Users mailing list archive at
 
Nabble.com.
 _______________________________________________
 users mailing list
 users(a)xwiki.org
 
http://lists.xwiki.org/mailman/listinfo/users
 _______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users