looking for speed

From: Jerry Preston <g-preston1_at_ti.com>
Date: Tue, 12 Oct 2004 05:17:37 -0500
Message-ID: <ckgb02$iu6$1@home.itg.ti.com>

Hi!

I have a simple table with 25k plus entries. Currently I am using the following and it is very slow:

  my $sql="select Name, Address, ID

           from   data_status
           where  TRASHED = 'NOT'
           and    NOT     = '$not'
           and    TP        = '$area'";

  print "$sql<BR>" if $DEBUG;
  my $sth=$dbh->prepare($sql) || die "$DBI::errstr\n";   $sth->execute() || die "Cannot execute Statement - build sort tables!!<br>$DBI::errstr";

  while( my ( $Name, $Address, $ID ) = $sth->fetchrow() ) {
.
.

  }

Is there any way to speed this up?

Thanks,

Jerry Received on Tue Oct 12 2004 - 05:17:37 CDT