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

On Tue, 9 Jul 2002 16:31:50 -0230, you wrote: >> 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; >> } >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...) I'm a bit confused... what SQL statement are you executing against the database? It kinda looks like you're returning every row in the database, and using PHP to find the one that matches. Why can't you use a WHERE clause? djo