Re: Performance differences, BLOB vs LONG RAW

Allan Jones wrote:

> Hi Folks
>
> Has anyone experienced a difference in performance between using LONG
> RAW and BLOBs when adding new records? I have a table which contains
> a BLOB (which will contain just a few bytes). The update performance
> is significantly worse using a BLOB field than if I change to using
> LONG RAW. I suspect that the difference may be due to Oracle returning
> BLOB Locators.
>
> I'm using ADO and Oracle's ODBC driver. The record is added using
>
> pRecordset->AddNew(vFieldList, vValueList);
>
> where the variant parameters have been populated with indexes and
> data.
>
> I don't need the BLOB Locator since this app will not access the data
> once it is stored but I do need better performance. Is there any way
> to turn off this feature?
>
> Any hints or suggestions?
>
> Thanks in advance
>
> Allan

Oracle has clearly said to stop using LONG RAW some time ago. Most likely they are going away in the near future.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)