General developer forum

Hi Janne,

this is discussed more in depth in the Servers and Performance forum. My recommendations are, in order of impact:

• Yes! Use 1.9 as soon as you can (note that it is in still in beta these days)
• Use a recent linux distro, targetted to servers, with a recent kernel - such as 2.6.16 or newer. Debian or the server edition of Ubuntu ideally.
• Disk IO is your main bottleneck, specially for the DB work. Several pairs of SCSI disks setup in RAID-1. Separate the workloads of the RAID-1 pairs - this is a well known practice for DBAs -- what you want are dedicated spindles for each task
• Lots of memory on the DB server, and tell the DB to use all that memory for caches /& sorting
• Lots of memory on the webserver, and maxclients set to match
• Ensure the lowest latency possible between DB and webserver if they are split up
• eAccelerator or similar on the webserver
• noatime and other FS tweaks on the webserver
• Appropriate FS tweaks for your DB
• 64bit OS & Opteron CPUs on the DB server
• 32-bit and cheap CPUs on the webserver
• Run sysstat to collect system load logs -- it is by far the best stat collection package and will capture important stuff noone else does

Things to avoid:

• 64-bits on the webserver. Unstable, eats lots more memory.
• MySQL Cluster
• Windows/IIS
• SANs
• Running inside a virtualisation guest
• Don't build by hand - we spend 99% of the time waiting for the DB, making the 1% slightly faster won't change anything - it is not worth it

HTH

    if ( $rs && $rs->RecordCount() > 0 ) {
        // Check if adodb_getall exists...
        if ( function_exists('adodb_getall') ) {
            if ( $records = adodb_getall($rs) ) {
                foreach ( $records as $record ) {
                    if ( $CFG->dbfamily == 'oracle' ) {
                        array_walk($record, 'onspace2empty');
                    }
                    $objects[current($record)] = (object) $record;
                }
                return $objects;
            } else {
                return false;
            }
        } else {
            while ( !$rs->EOF ) {
                if ( $CFG->dbfamily == 'oracle' ) {
                    array_walk($rs->fields,'onespace2empty');
                }
                $objects[current($rs->fields)] = (object) $rs->fields;
                $rs->MoveNext();
            }
            return $objects;
        }
    } else {
        return false;
    }