Re: SELECT FOR UPDATE ok, but how to dereference

[Tim Bunce]

On Mon, May 20, 2002 at 11:57:32PM -0700, Zachary Buckholz wrote:
> Thanks for the response Ilya -
> 
> It's been over 10 minutes now and it's still running,


It's still running because that's what you've told it to do:

  while (my $url_list = $dbh->selectall_arrayref($select_query, undef, $current_time)
        or die "Can't execute statement: $DBI::errstr") {
     ...
  }

round and round and round and round ... selecting *all* the rows each time ...

Tim.