History of bitweaverPerformance
Version 9
bitweaverPerformance
Tips and Techniques for High Performance bitweaver
SysAdmin Tools
- MultiTail - tail on steroids
Apache
Make sure you have an Advanced Apache Configuration for High Traffic SitesPHP
- Use Fast Coding Habits
- Install ImageMagick's Magickwand for better image handling
- Install pecl fileinfo for better type checking on file uploads
- 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