How to improve TikiWiki performance for high-volume & high availibility sites

Performance

A number of enhancements to help improve performance and scalability are being developed for the Firefox Support (external link)

site, aka SUMO (SUpport MOzilla)

SUMO reports 10 million page hits per week (external link)

http://www.afup.org/templates/forumphp2008/resumes/137-scaling_mozilla.pdf
http://www.baohx.com/extras/zendcon/Gordon-ZendCon%202008.ppt
SUMO Tiki from mozilla code repository.

Nelson suggested a new admin panel (tiki-admin.php?page=performance) for all the settings specific to performance. Two settings in tiki-admin.php?page=search ("Ignore individual object permissions" and "Ignore category viewing restrictions") should be copied over.

Patches: please help to merge

make querying of category perms only happen once for each access, instead of each perm
do not translate english not wnated for 2.0
cache in memory whether in daylight saving, also default to pacific time always but note correction make timezone adjustment work again (should not be that much more load, and useful for forum
Make use of Smarty cache Please read for context: https://bugzilla.mozilla.org/show_bug.cgi?id=425614
cache locale date strings done in 2.0 (sept_7)
cache userlink results in memory
Reported posts page never loads
cache get_object_permissions_for_user results done in 2.0 (sept_7)
flip order of include_path so as to reduce disk access done in 2.0 (sept_7)
Improve performance of forums but note:
- part of this involves removing the "next/prev thread" feature which might still be needed, so need to merge in to optionality.
- Also note correction fix number of forum threads to list not being observed, and filter by time not working See https://bugzilla.mozilla.org/show_bug.cgi?id=424676 for more info.
- Sorry that all these patches got merged as one svn commit (it should have been separate)
Allow non-logged in users to function without PHP sessions (to reduce session overhead) and to enable use of forward proxy caches (This whole thing will have to be an optional feature)
- note need to ajaxify captcha
- Add TikiWiki cache for preferences when not logged in
- how to allow for setting of cache-control headers and custom php session id for users that are not logged in for forward proxy-handling
- Note related Add TikiWiki cache for preferences when not logged in
- Note need to have language/locale setting in the URL (otherwise proxy caching will not give predictable results). The way to handle this still needs to be cleaned up. Patches are all over the place right now.

More information coming about:

using pdo instead of adodb
using eaccelerator
using memcached

Please also see:

My own testing gives very different results than:
http://www.bitweaver.org/wiki/Speed+optimisation (external link)

Wishlist

Rating	Subject	Priority	Report type	Feature	Created
1/1	Tracker Limitation of 3000-5000 entries	6	Bug: Usability	Performance / Speed / Load Trackers	2009-03
2/4	Deeply nested large file galleries slow to a crawl when file browsing	5	Bug: Usability Support request	File Gallery Performance / Speed / Load	2008-10
2/2	User tasks on dev.tikiwiki.org is mega slow (60+ seconds for some operations)	3	Bug: Error	Database MySQL Performance / Speed / Load Task	2007-08
-	output handler 'ob_gzhandler' cannot be used after 'URL-Rewriter' in tiki-setup.php on line 1890	1 low	Bug: Error	Cache Installer (profiles, upgrades and server-related issues) Performance / Speed / Load Search engine optimization (SEO)	2007-08