Re: Re: Working under Apache 1.3 but not Under IIS (Problem Resolved But its too Slow)...

Index your database on the name and password fields and issue this query Select count(*) where name = '$namevar' and password = '$passvar' If count > 0 you have a hit, proceed with rest of authentication, else send appropriate error msg. Whatever you do, DON'T make sequential searches through a database. They are agonizingly slow. Regards - Miles Thompson PS cs.mun.ca is different, where are you located? At 04:31 PM 7/9/2002 -02-30, you wrote:

I got it fixed by changing the Max Execution Time in the php.ini file... However, this is ridiculously slow... Does anyone else have any idea how I can run through a 4 MB+ Database checking 2 fields Without having to wait longer than 30 seconds... If it was a simple text file it would have been easy using different search strategies (possibly even Hashing Keys...) Please give me some suggesstions... Kondwani... "Kondwani Spike Mkandawire" <kondwani@cs.mun.ca> wrote in message news:20020709182154.13290.qmail@pb1.pair.com... The function shown below only functions with my Apache on WinNT... I have tried it on my local Server (thats the one running the Apache and it works perfectly)... I am trying to step through a moderately large database (4MB)... However when I tried the example on the Server for my Work Place it returned an error stating that the Script took longer than 30 seconds to execute hence failed... When I search for a name at the top of the Database it immeadiately Spits out Found!... The server on which this fails is an IIS WebServer, I am not quite sure what version it is... I am kind of at a loss whether its to do with the scripts efficiency or the Servers Settings... Why is it possible to execute the Script easily on my local host... Here is the location... http://www.coop.mun.ca/verification.php Try and Type in any Name... As it should simply Step through the Database not find it and Respit the Page... However this does not happn... Please Help... if (function_exists(odbc_fetch_array)) return; function odbc_fetch_array($result, $rownumber=-1) { if (PHP_VERSION > "4.1") {

    if ($rownumber < 0) {
      odbc_fetch_into($result, &$rs);
    } else {
      odbc_fetch_into($result, &$rs, $rownumber);
    }

} else {

    odbc_fetch_into($result, $rownumber, &$rs);

} foreach ($rs as $key => $value) {

    $rs_assoc[odbc_field_name($result, $key+1)] = $value;

} return $rs_assoc; } -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php