History of bitweaverPerformance
Version 8
bitweaverPerformance
Tips and Techniques for High Performance bitweaver
Apache
Make sure you have an Advanced Apache Configuration for High Traffic SitesPHP
- Use Fast Coding Habits
- Install an Accelerator
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:
# psql foo < /usr/share/pgsql/contrib/tablefunc.sql
Then to your config_inc.php, add:
<?php
define( 'POSTGRESQL_CONTRIB', TRUE );
?>
Areas to investigate for Code Opimizations
- ADODB