Re: DBD::Oracle dbd_st_execute slow speed

  On 16/12/2010 7:06 AM, Ludwig, Michael wrote:
>> -----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?
yep It might I could ask an oracle buddy of mine who works on it if you 
want?

Its been a while since the last time I tried to get OCI treads to work 
but in the case of an update statement it would make perfect sense to 
use them for that as there is no 'return' from the DB like 'select' 
statement.

SQLplus might also be using the array interface under the hood for all 
inserts which could be faster.

You can give that a try by using the execute_array function with the 
same insert.

Cheers
John Scoles
> 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