Re: Performance differences, BLOB vs LONG RAW

From: Allan Jones <AllanInChina2001_at_yahoo.com>
Date: 21 Feb 2005 04:03:52 -0800
Message-ID: <df1b8376.0502210403.72c5d406@posting.google.com>

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 Received on Mon Feb 21 2005 - 06:03:52 CST