Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001071

RE: [PHP-DB] Random Password Generation/MSSQL From: Mark Roedel (MarkRoedel <email protected>)
Date: 07/12/01

> -----Original Message-----
> From: Ryan Marrs [mailto:rmarrs <email protected>]
> Sent: Thursday, July 12, 2001 1:54 PM
> To: php-db <email protected>
> Subject: [PHP-DB] Random Password Generation/MSSQL
>
>
> Having an issue with this script, the generator works if I
> just echo out the password, however when I attempt to update
> the table, it times-out in IIS. I've bumped the IIS Timeout
> up to over 20 minutes, and it still times out. This is on a
> database with approximately 29,000 entries. Any ideas?
>
> [snip]
>
> for($i=1;$i<=$count;$i++){
> $DUNSNumber=$row->DUNSNumber;
>
> echo rand_pass()."<br>";

I bet if you

  echo $insertquery

right here, you won't see what you were expecting to. (Hint: $password
and $DUNSNumber aren't set when you give $insertquery its value; neither
is the string updated for each iteration of this loop.)

> MSSQL_QUERY($insertquery);
> }

Perhaps that's not the entire problem, but it can't be helping...if
nothing else, once that's corrected maybe you can start looking at doing
those updates in smaller batches. 20 minutes does seem a bit extreme,
but then it's hard to make much of a judgment on that without knowing
more about the machine in question, what else it's being used for
besides sql services, how heavily it's being utilized, etc. 

---
Mark Roedel           | "Nothing in life is so bad that it cannot be
Systems Programmer    |   made much, much worse by the addition of
LeTourneau University |    lots of spikes and razors."
Longview, Texas, USA  |                                -- Sean Kozma 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>