Re: Working under Apache 1.3 but not Under IIS (Problem Resolved But its too Slow)...
| From: | Kondwani Spike Mkandawire | Date: | Tue, 09 Jul 2002 19:01:50 +0000 |
| Subject: | Re: Working under Apache 1.3 but not Under IIS (Problem Resolved But its too Slow)... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-106426@lists.php.net to get a copy of this message | ||
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;
> }
>
>