Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Performance differences, BLOB vs LONG RAW

Re: Performance differences, BLOB vs LONG RAW

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Mon, 21 Feb 2005 07:18:27 -0800
Message-ID: <1108998931.908925@yasure>


Allan Jones wrote:
> DA Morgan <damorgan_at_x.washington.edu> wrote in message news:<1108940431.426060_at_yasure>...
>
>

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

>
>
> I'm well aware of this, which is one of the reasons that I intend to
> use BLOBs. My question was;
> 1) is the performance difference I'm seeing to be expected and if so,
> 2) what can I do to improve it.
>
> As I do not require the BLOB locators since I will never access the
> data directly, it seems that there must be some performance gain to be
> had if I can tell Oracle not to try to return them.
>
> regards
>
> Allan

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.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Mon Feb 21 2005 - 09:18:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US