#20901 [Bgs->Opn]: Query to MySQL hangs for 90sec from Netscape 4.08

ID: 20901 User updated by: judd@ob-wan.com Reported By: judd@ob-wan.com -Status: Bogus +Status: Open Bug Type: Performance problem Operating System: Win2K Server PHP Version: 4.2.3 New Comment: Sniper, It can, and it does. If you hadn't been in such a hurry to discount the zipfile I sent you, many of these problems would now be dust. Evidently everything is useless to you. Less haste, more speed. Previous Comments: ------------------------------------------------------------------------ [2002-12-09 07:49:04] sniper@php.net That script is really useless to us. And FYI, the used browser has ABSOLUTELY NOTHING to do with how long PHP runs some script. Bogus. ------------------------------------------------------------------------ [2002-12-09 07:43:04] judd@ob-wan.com Try this one, it really takes ages: function verify_login($username, $password) { /* verify the username and password. if it is a valid login, return an array * with the username, firstname, lastname, and email address of the user */ $qid = db_query(" SELECT username, firstname, lastname, email, priv FROM users WHERE username = '$username' AND password = '" . md5($password) . "' "); return db_fetch_array($qid); } ------------------------------------------------------------------------ [2002-12-09 06:21:52] msopacua@php.net Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.php.net/how-to-report.php If you can provide more information, feel free to add it to this bug and change the status back to "Open". Thank you for your interest in PHP. AFAIK, no browser is able to access MySQL, so some example code would be pleasant. ------------------------------------------------------------------------ [2002-12-09 06:04:06] judd@ob-wan.com Querying MySQL takes an awfully long time from Netscape. I am running 4.08 and cannot comment about other versions. IE 5.5 does not display this problem. A clue to debugging this is that changing focus after the query brings the result back immediately. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=20901&edit=1