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
