Justtechjobs.com Find a programming school near you






Online Campus Both


php3-list | 2000051

[PHP3] oracle connection / process problem From: Alex Black (enigma <email protected>)
Date: 05/12/00

hi,

I'm stress testing a PHP / Oracle application, and have noticed that I can
kill the machine quite easily...
--------------
3104 ? 00:00:00 httpd
 3111 ? 00:00:00 oracle
 3105 ? 00:00:02 httpd
 3108 ? 00:00:03 oracle
 3106 ? 00:00:06 httpd
 3115 ? 00:00:07 oracle
--------------

this type of thing expands very rapidly until oracle reaches its process
limit, and the machine dies.

My Database connection function, which is called every time a page is
loaded:

-------------------------------
function db_connect(){
 putenv("ORACLE_SID=LOCM");
 putenv("ORACLE_HOME=/export/home/oracle/.../");
 global $oracle_username;
    $oracle_username = "username";
 global $oracle_password;
    $oracle_password = "password";
if (empty($ret)) {
 $ret =  <email protected>($oracle_username,$oracle_password);
 db_check_errors($php_errormsg);
}
 return $ret;
}
-------------------------------

I do not call a close function at the end of every page, instead I am trying
to check for the existence of a connection... but I must be doing it wrong.

What techniques should I be using to solve this scale problem?

any help much appreciated.

thanks,

_alex 

-- 
PHP 3 Mailing List <http://www.php.net/>
To unsubscribe, send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest, e-mail: php3-digest-subscribe <email protected>
To search the mailing list archive, go to: http://www.php.net/mailsearch.php3
To contact the list administrators, e-mail: php-list-admin <email protected>