Thanks. So the next question... Is an extra soft parse a significant overhead? (For some value of 'significant' :)
Tim. On Thu, Nov 28, 2002 at 06:23:11PM -0800, Jared Still wrote: > > The first parse is a 'hard' parse. This is the parse that > checks for existance of tables, privileges, and a bunch of > other stuff I probably don't know about. > > The second parse is a 'soft' parse. It checks for existence > of the SQL in the Oracle library cache. > > Oracle-Tools may not differentiate, or you may be on an > older version of Oracle that reported them as equivalent. > > Jared > > > > On Thursday 28 November 2002 04:13, Tim Bunce wrote: > > Try $dbh->prepare($call, { ora_check_sql => 0 }); > > > > (The underlying issue is either an Oracle bug or that one of the > > two parse steps counted isn't a real parse. DBD::Oracle does a > > 'describe only' execute at prepare() time and then a normal execute > > when execute() is called. The execute() should not count as a parse > > as it has already been parsed, but oracle seems to do, or at least > > count, another parse.) > > > > Tim. > > > > p.s. This is not about the development of drivers so belongs on > > dbi-users and not on dbi-dev. > > > > On Thu, Nov 28, 2002 at 11:37:59AM +0100, Henning Meyer wrote: > > > Hello, > > > > > > I use Perl 5.6.0, DBI 1.30 and DBD-Oracle 1.12. > > > While checking the performance, my Oracle-Tools discovered, that the > > > Database does two prepares for every > > > execute. > > > > > > My Perl-Code looks like this: > > > > > > my $cur=$dbh->prepare($call); > > > die "Prepare-Error: $DBI::err\n$call\n$DBI::errstr\n" if > > > ($DBI::err); > > > $cur->execute(@$vars); > > > die "Execute-Error: > > > $DBI::err\n$call\n$DBI::errstr\n" if > > > ($DBI::err); > > > my @res=(); > > > while (my $href=$cur->fetchrow_hashref) { > > > die "Fetch-Error: $DBI::err\n$call\n$DBI::errstr\n" if > > > ($DBI::err); > > > for(keys %$href) { > > > $href->{$_}=~s/[\s]*$//; > > > $href->{$_}=~s/^[\s]//; > > > } > > > push(@res,$href); > > > } > > > $cur->finish; > > > return(\@res); > > > > > > How could it be, that there is an prepare/execute ratio of 2? I have > > > execute much equal +statements with bind-Values, and its very annoying > > > that there are 400 prepares for 200 +executes instead of one prepare. > > > > > > Any hints? > > > > > > Henning > > > > > > -- > > > ''' > > > (0 0) > > > +-------oOO----(_)-------------+ > > > > > > |Henning Meyer | > > > |SIEMENS AG ICM N PG ES PD D 2| > > > > > > +--------------------oOO-------+ > > > > > > |__|__| > > > > > > ooO Ooo