AllanInChina2001_at_yahoo.com (Allan Jones) wrote in message news:<df1b8376.0502240710.3e55f930_at_posting.google.com>...
> DA Morgan <damorgan_at_x.washington.edu> wrote in message news:<1108998931.908925_at_yasure>...
>
> > I don't know if it is expected because I don't know what version you
> > are using or what you are storing. I've not seen enough of a delta
> > to make me investigate further.
>
> I'm using Oracle 10g on Windows 2000. Oracle ODBC driver 10.01.00.02.
> I've spent a few minutes today settings up a simple test. I have two
> tables JUNK1 and JUNK2.
>
> JUNK1 contains;
> COL1 NUMBER
> COL2 NUMBER
> COL3 BLOB
>
> JUNK2 contains
> COL1 NUMBER
> COL2 NUMBER
> COL3 LONG RAW
>
> Apart from the different data type for COL3, both tables are
> identical. I have listed below a bit of code which uses ADO to insert
> 20000 rows. For JUNK1 this runs in about 31 seconds. If I change the
> command string so it inserts into JUNK2 the time is around 15 seconds.
> I've tried the same thing using a recordset to do the insert and have
> seen similar difference in performance.
>
> Any ideas?
>
Looking at this again, I've tried the same thing using Oracle's OleDb
driver rather than going through ODBC and this seems to solve the
performance problem. It needs a code change because the driver doesn;t
seem to be able to derive parameter information.
Received on Fri Mar 04 2005 - 09:24:00 CST
