exing
your tables is what you need to improve the performance in this case.
Steve H.
-Original Message-
From: Hastie, Christa [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 02, 2001 12:58 PM
To: [EMAIL PROTECTED]
Subject: ::massive sql query using dbi - please help::
Hello to all!
T
t;fetchrow_arrayref) {
> print LOG "$row->[0]\t$row->[1]\n" or die "Error: $!\n";
> }
>
> flock (DATATEMP, $unlock_lock);
> close (LOG);
>
> $sth->finish;
> $dbh->disconnect;
> exit;
>
> -Original Message-
> From: Marc
gt;[1]\n" or die "Error: $!\n";
}
flock (DATATEMP, $unlock_lock);
close (DATATEMP);
-Original Message-
From: Hastie, Christa
Sent: Friday, November 02, 2001 11:53 AM
To: 'Marcelo Guelfi'; [EMAIL PROTECTED]
Subject: RE: ::massive sql query using dbi - please help::
hrow_arrayref) {
print LOG "$row->[0]\t$row->[1]\n" or die "Error: $!\n";
}
flock (DATATEMP, $unlock_lock);
close (LOG);
$sth->finish;
$dbh->disconnect;
exit;
-----Original Message-
From: Marcelo Guelfi [mailto:[EMAIL PROTECTED]]
Sent: Friday,
Christa" To: [EMAIL PROTECTED]
Hello to all!
This is my first time posting to this group! But I'm in desperate need of
any help!
(BTW, thanks for all the emails from contributors to this list..I learn a
lot from you guys every day!)
I have two tables in a mySQL db, named users_old and users_new, both with
UserId and Email c
