Mark D Powell wrote:
> "Jerry Preston" <g-preston1_at_ti.com> wrote in message news:<ckgb02$iu6$1_at_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
>
Also, look into:
my $sth=$dbh->prepare_cached($sql,{ora_check_sql=>0}) ...
To prevent doing double parses etc (which used to be the default)
Received on Tue Oct 12 2004 - 20:23:13 CDT