Actually the sqlstatement takes a while with the sqlplus as well, so I guess
it might be a tuning issue.
Anyway, Here is a snip of my code, with a lot of time checks:
($sec, $min, $hour, $mday, $mon, $year, $wday, $yday, $isdst) =
localtime(time);
print "Time before preparing sqlstatement: $hour $min $sec <br>";
my $sth = $dbh->prepare( $sql );
print "$sql <br>";
($sec, $min, $hour, $mday, $mon, $year, $wday, $yday, $isdst) =
localtime(time);
print "Time before executing the sqlstatement: $hour $min $sec <br>";
$sth->execute();
($sec, $min, $hour, $mday, $mon, $year, $wday, $yday, $isdst) =
localtime(time);
print "Time after executing the sqlstatement, before binding to columns:
$hour $min $sec <br>";
$sth->bind_columns( @AllBcol );
($sec, $min, $hour, $mday, $mon, $year, $wday, $yday, $isdst) =
localtime(time);
print "Time after binding to columns: $hour $min $sec <br>";
I can se in the time-outputs, that it takes a very long time doing the
execution
/Michelle
Michael Nhan wrote:
> Hi,
>
> Can you post snipet of code so we can assist you? Include the sql
> statement if possible? Does the same statement work quickly on sqlplus?
> If not then its probably a sql statement/database tuning issue.
>
> Michael
>
> On Tue, 12 Jun 2001, Michelle Gerfort wrote:
>
> > Date: Tue, 12 Jun 2001 15:17:28 +0200
> > From: Michelle Gerfort <[EMAIL PROTECTED]>
> > To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> > Subject: Slow execution
> >
> > Hi there
> >
> > I use an ordinary
> > $sth->execute();
> > but it seems to take ages to search, creating or updating a post.
> > Is this problem due to the sqlstatement or is it a known problem with a
> > perl DBI interface?
> >
> > I run Oracle 7.3.3 on an AIX 4.2 with roxen as webserver.
> >
> > --
> > MVH
> > Michelle
> >
> > -----------------------------------
> > Michelle Gerfort
> > Software Engineer
> >
> > Teligent AB
> > P.O. Box 1191
> > SE-581 11 Link�ping, Sweden
> >
> > www.teligent.se
> >
> >
> >
--
MVH
Michelle
-----------------------------------
Michelle Gerfort
Software Engineer
Teligent AB
P.O. Box 1191
SE-581 11 Link�ping, Sweden
www.teligent.se
