History of bitweaverPerformance
This page is still just a ##stub##.
!PHP
# Install an Accelerator
Installation of a PHP opcode caching mechanism like [http://turck-mmcache.sourceforge.net/|turck-mmcache] will dratically reduce PHP memory usage and improve execution time.
!((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}
!PHP
# Install an Accelerator
Installation of a PHP opcode caching mechanism like [http://turck-mmcache.sourceforge.net/|turck-mmcache] will dratically reduce PHP memory usage and improve execution time.
!((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}