History of bitweaverPerformance

{maketoc}

!Apache
Make sure you have an ((Advanced Apache Configuration for High Traffic Sites))

!PHP
* Use [http://www.php.lt/benchmark/phpbench.php|Fast Coding Habits]
* Install an Accelerator
Installation of a PHP opcode caching mechanism like [http://eaccelerator.net/HomeUk|php-eaccelerator] ( which is a maintained version of [http://turck-mmcache.sourceforge.net/|turck-mmcache] ) will dratically reduce PHP memory usage and improve execution time. It is available as a yum installable Fedora extra rpm.

!((dbTuning: PostgresAdvocacy|Postgres))
Install the tablefunc contribution to achieve massive optimization of GatekeeperPackage security look ups. tablefunc has the Oracle'esque "connectby" function that will let you execute recurisve queries on a hierarchical table that has id/parent_id rows, ala the tiki_fisheye_gallery_map. To install, make sure you have installed teh postgresql-contrib rpm/deb/whatever, and execute something like this FedoraCore 3 command line:
{code in="bash"}# psql foo < /usr/share/pgsql/contrib/tablefunc.sql{code}
Then to your config_inc.php, add: {code in="php}define( 'POSTGRESQL_CONTRIB', TRUE );{code}

!Areas to investigate for Code Opimizations
*ADODB
If writing code, see the [http://phplens.com/lens/adodb/docs-adodb.htm#speed|Tuning tips] and install the [http://adodb.sourceforge.net/#extension|ADODB C Extension]