Welcome Guest, Not a member yet? Register   Sign In
Multiple database + pconnect issues
#9

[eluser]Nanodeath[/eluser]
Hmm...I think any function with any sort of complexity should be avoided at all costs, if we're to keep queries efficient. Here's another idea, with my discovery of the mysql_thread_id function (PHP 4.3.0):

Code:
function db_pconnect(){
    $ret = @mysql_pconnect($this->hostname, $this->username, $this->password);
    if($ret){
        $this->_thread_id = mysql_thread_id($ret);
    }
    return $ret;
}

var $_thread_id = FALSE;

function db_select(){
    static $selected_db = array();
    if($this->_thread_id !== FALSE) {
        if(array_key_exists($this->_thread_id, $selected_db) && $selected_db[$this->_thread_id] == $this->database){
            return TRUE;
        }        
        $selected_db[$this->_thread_id] = $this->database;
    }
    return @mysql_select_db($this->database, $this->conn_id);
}

This feels like a coding duel for some reason Tongue


Messages In This Thread
Multiple database + pconnect issues - by El Forum - 02-20-2008, 10:16 PM
Multiple database + pconnect issues - by El Forum - 02-21-2008, 06:10 AM
Multiple database + pconnect issues - by El Forum - 02-21-2008, 09:51 AM
Multiple database + pconnect issues - by El Forum - 02-21-2008, 10:33 AM
Multiple database + pconnect issues - by El Forum - 02-21-2008, 02:19 PM
Multiple database + pconnect issues - by El Forum - 02-21-2008, 03:47 PM
Multiple database + pconnect issues - by El Forum - 02-21-2008, 04:25 PM
Multiple database + pconnect issues - by El Forum - 02-21-2008, 04:39 PM
Multiple database + pconnect issues - by El Forum - 02-21-2008, 05:00 PM
Multiple database + pconnect issues - by El Forum - 02-21-2008, 05:20 PM
Multiple database + pconnect issues - by El Forum - 02-21-2008, 05:25 PM
Multiple database + pconnect issues - by El Forum - 02-21-2008, 05:40 PM
Multiple database + pconnect issues - by El Forum - 02-21-2008, 06:16 PM
Multiple database + pconnect issues - by El Forum - 02-21-2008, 06:47 PM
Multiple database + pconnect issues - by El Forum - 02-21-2008, 06:58 PM
Multiple database + pconnect issues - by El Forum - 02-21-2008, 07:04 PM
Multiple database + pconnect issues - by El Forum - 02-21-2008, 07:14 PM
Multiple database + pconnect issues - by El Forum - 02-21-2008, 07:24 PM
Multiple database + pconnect issues - by El Forum - 02-21-2008, 07:39 PM
Multiple database + pconnect issues - by El Forum - 05-01-2008, 08:48 AM
Multiple database + pconnect issues - by El Forum - 05-19-2008, 09:35 PM
Multiple database + pconnect issues - by El Forum - 05-20-2008, 06:26 AM
Multiple database + pconnect issues - by El Forum - 06-11-2008, 09:39 AM
Multiple database + pconnect issues - by El Forum - 06-11-2008, 02:19 PM
Multiple database + pconnect issues - by El Forum - 07-28-2008, 02:47 AM
Multiple database + pconnect issues - by El Forum - 07-28-2008, 03:06 AM
Multiple database + pconnect issues - by El Forum - 07-28-2008, 09:24 PM
Multiple database + pconnect issues - by El Forum - 07-29-2008, 01:11 AM
Multiple database + pconnect issues - by El Forum - 07-29-2008, 07:07 PM
Multiple database + pconnect issues - by El Forum - 07-30-2008, 02:46 AM



Theme © iAndrew 2016 - Forum software by © MyBB