RE: DBD::Oracle dbd_st_execute slow speed

[email protected] ("Ludwig, Michael")
Newsgroups perl.dbi.users
Message-ID <[email protected]>
> -----Original Message-----
> From: John Scoles

> More likely SQLplus is spawning a thread while DBD::Oracle does not.

You mean performing the actual work in the background while making
the prompt available for the user to enter the next command?

Oracle's sqlplus doesn't appear to have a -verbose switch, but maybe
there is an option you can set on the connection to find out what's
going on inside.

> >          This still doesn't explain the difference between 
> DBD::Oracle and
> > sqlplus. They must have had different execution plans 
> internally somehow.

Michael
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.