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 PROTECTED]]
Sent: Tuesday, June 12, 2001 6:17 AM
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.
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.
