Tweaks, please remember I didn't personally write these! Some may contain duplicate/conflicting tweaks! Ineo: Use UDG for MySQL connection
Ineo: Getting max from your hardware.
Ineo: Server-level optimizations
Client Center KB: Changing Sessions table type to HEAP
Using Caching Methods Update !
I've been discovering other methods to speed up page views. Using Memcached
Tell your sysadmin to install the memcached server set it to use 128mb ram or so and add this bit below in the conf_global.php, of course replace the info with your setup's. You'll also need the pecl memcache module. $INFO['use_memcache'] = 1;
$INFO['memcache_server_1'] = "SERVER ADDRESS HERE";
$INFO['memcache_port_1'] = "SERVER PORT HERE";
If you're running a cluster and the mysql server has a lower load I recomend to run memcached server on it.