Hi again
Just got to work again.
Thank you all for your answers! And I can see your point in "This is not a
DBI question". This problem was actually caused by wrong indexes in the
database.
Anyway- I think this it's nice when this mailing list can link to other
areas where the problems can be fo
This is not a DBI question.
There's no reason that DBI would take any more
time than the same query in SQL*Plus. Try the query there, get
a query execution plan, see if you have missing indexes, need to
create indexes, etc.
-Original Message-
From: Michelle Gerfort [mailto:[EMAIL PROTECT
Can you provide an example?
-Original Message-
From: Michelle Gerfort [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 12, 2001 09:17
To: [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
une 2001 14:29
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: Slow execution
>
>
>
> I am also facing this kind of stuff. But I see the problem
> in SELECT only.
> I am joining 6 tables some of them from other databases. and
> when I run the
> query on SQ
Is that the
> problem?
>
> Regards,
> Prem
>
>
>
>
> -Original Message-
> From: Michelle Gerfort [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 12, 2001 9:29 AM
> To: Michael Nhan; [EMAIL PROTECTED]
> Subject: Re: Slow execution
>
>
> Actually th
the
problem?
Regards,
Prem
-Original Message-
From: Michelle Gerfort [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 12, 2001 9:29 AM
To: Michael Nhan; [EMAIL PROTECTED]
Subject: Re: Slow execution
Actually the sqlstatement takes a while with the sqlplus as well, so I guess
it might be
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
