Performance

SUMO

Todo

• Add an new admin panel (tiki-admin.php?page=performance) for all the settings specific to performance Done in Tiki4 Two settings in tiki-admin.php?page=search ("Ignore individual object permissions" and "Ignore category viewing restrictions") should be copied over.
  • Make a section "Features known to slow down Done in Tiki4
    • Phplayersmenu Done in Tiki4
• Filtering Best Practices picking the right filters improves performance
• Port all performance related enhancements to Tiki

• 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.
• Architecture Suggestions From Mozilla

Patches: please help to merge

• make querying of category perms only happen once for each access, instead of each perm
• do not translate english Should be option in performance admin panel
• 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.

• using pdo instead of adodb (Done for 4.0)
• using eaccelerator
• using memcached ( Zend_Cache_Backend_Memcached deserves a look.)

• Content delivery network
• Yslow
• Memory consumption
• Tracker Performance
• load balancing
• cacheing
• ADOdb Lite
• etc

Wishlist

Open

	Rating	Subject	Priority	Category	Created
	(3)	Blocking query in trackers code	9 high	Bug: Error	2009-06
	(0)	Improve YSlow scores	8	Feature request Patch	2009-08
	(1)	Tracker performance improvements	8	Bug: Usability Support request	2010-01
	(1)	renaming or deleting a wiki page doesn't update the link seen from CATEGORY plugin	7	Bug: Error Bug: Usability	2008-06
	(1)	Cached images are broken on themes.tw.o (feature broken?)	6	Bug: Error	2008-12
	(1)	Tracker Limitation of 3000-5000 entries	6	Bug: Usability	2009-03
	(1)	Tracker list plugin cache is showing a hash	5	Bug: Error	2008-01
	(0)	_categorized-Permissions cannot be assigned when upgrading from 1.9 to 1.10 - cache problem	5	Bug: Error	2008-03
	(2)	Deeply nested large file galleries slow to a crawl when file browsing	5	Bug: Usability Support request	2008-10
	(1)	Activating plugins doesn't invalidate cache and thus, plugin help doesn't appear on next page edit	5	Bug: conflict of two features (each works well independently) Bug: Consistency	2009-05
	(1)	Menu cache problem	4	Bug: Error	2005-11
	(0)	virtual wikis seem to share cache for groups and categories drop down lists	4	Bug: Usability	2007-04
	(1)	PHP ERRORS and NOTICES using 5.2.6	4	Bug: Error	2008-10
	(0)	Check & report broken links	3	Feature request	2006-03
	(0)	Smarty cache is not automatically updated after a modification of language.php	3	Bug: Usability	2007-03
	(1)	User tasks on dev.tikiwiki.org is mega slow (60+ seconds for some operations)	3	Bug: Error	2007-08
	(1)	smarty template cache path exceeding maximum lenght	2	Bug: Error	2005-11
	(0)	Annotations: doesn't work well with wiki page cache	2	Bug: conflict of two features (each works well independently)	2008-12
	(0)	tiki-admin_system.php -> the stats are all wrong and should show only 1 langue if not i18n site	2	Bug: Error	2009-04
	(1)	output handler 'ob_gzhandler' cannot be used after 'URL-Rewriter' in tiki-setup.php on line 1890	1 low	Bug: Error	2007-08
	(0)	(2.2) Invalid offset in lib/tikilib.php : 6193 (when dealing with cached pages)	1 low	Bug: Error	2009-02
	(2)	dev.tw.o: Sorting items from trackerlist plugin doesn't work for anons due to cache issue	1 low	Bug: conflict of two features (each works well independently) Feature request	2009-11
	(0)	setup.sh create unusable tikiwiki website if cache is full!		Bug: Usability	2009-07

Pending

	Rating	Subject	Priority	Category	Created
	(1)	Minify and cache js and css files, with an admin panel to refresh	9 high	Feature request Patch	2009-08
	(4)	Allow Tracker item rating to be seen or voted through PluginTracker and PluginTrackerList	7	Bug: Error Feature request	2007-06
	(0)	Long table truncated when presented as (cached)	6	Bug: Error	2006-08
	(1)	Tracker item list not refreshing after changes	6	Bug: Error	2007-08

Closed

	Rating	Subject	Priority	Category	Created
	(1)	New "cache" section or admin panel	8	Feature request	2007-01
	(3)	Wiki cache & plugins: WYSIWYCA problem when admin visits the page (and creates the cache)	6	Bug: Error	2007-06
	(3)	Wiki cache & plugins: WYSIWYCA problem when admin visits the page (and creates the cache)	6	Bug: Error	2007-08
	(1)	svn: Working copy 'temp/cache' is missing or not locked	7	Bug: Error Community projects	2008-07
	(1)	Add memcached support, with admin panel	8	Feature request Patch	2009-08

Also

https://sourceforge.net/tracker/index.php?func=detail&aid=902503&group_id=64258&atid=506846

2010-01-26 profiling on Tiki trunk (Tiki5)

Lessons learned from

• LPH did some profiling on several DBs that were sent in and proceeded to several performances commits.
• Lessons
  • Most problems caused by poor server config
  • Use new minified CSS (Tiki5) and JS (Tiki4)
  • PHP Layers menus is not cached. Use css menu for performance
  • Plugin sharethis causes flicker (could be better implemented)

Todo

Easy

Long term