Re: LONG RAW versus BLOB performance

Oracle has also recommended not using LONG in new applications since Oracle8

See
http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adfns typ.htm#427094.

Cheers,

John Thomas

In message <F001.005CD60A.20030826223927_at_fatcity.com>, Jared Still <jkstill_at_cybcon.com> writes
>
>Mark,
>
>Have you also considered the API to each?
>
>PL/SQL or Java can be used with LOBS. LONG RAWS of
>greater than 32K must be manipulated via a precompiler
>or OCI, not sure about Java.
>
>Jared
>
>On Tue, 2003-08-26 at 20:04, Mark Richard wrote:
>>
>> Hi everyone,
>>
>> I have been asked a question about the performance differences between LONG
>> RAW columns and BLOB columns. The columns would be used to store images
>> (probably JPG) so indexing of the column isn't an issue.
>>
>> I know of some of the implementation differences, such as an ability to
>> place BLOB's in their own tablespace, the ability to have multiple BLOB's
>> in the one table, etc, but know nothing about whether there is a real
>> performance difference in terms of writing and reading.
>>
>> If you have any information on this, or any pointers to articles I would
>> really appreciate them.
>>
>> Thanks,
>> Mark.
>>
>>
>><<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>
>> Privileged/Confidential information may be contained in this message.
>> If you are not the addressee indicated in this message
>> (or responsible for delivery of the message to such person),
>> you may not copy or deliver this message to anyone.
>> In such case, you should destroy this message and kindly notify the sender
>> by reply e-mail or by telephone on (61 3) 9612-6999.
>> Please advise immediately if you or your employer does not consent to
>> Internet e-mail for messages of this kind.
>> Opinions, conclusions and other information in this message
>> that do not relate to the official business of
>> Transurban City Link Ltd
>> shall be understood as neither given nor endorsed by it.
>>
>><<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>
>>
>>
>>
>>
>>
>><<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>> Privileged/Confidential information may be contained in this message.
>> If you are not the addressee indicated in this message (or
>>responsible for delivery of the message to such person), you may not
>>copy or deliver this message to anyone.
>> In such a case, you should destroy this message and kindly notify the
>>sender by reply e-mail or by telephone on (03) 9612-6999 or (61) 3
>>9612-6999.
>> Please advise immediately if you or your employer does not consent to
>>Internet e-mail for messages of this kind.
>> Opinions, conclusions and other information in this message that do
>>not relate to the official business of Transurban Infrastructure
>>Developments Limited and CityLink Melbourne Limited shall be
>>understood as neither given nor endorsed by them.
>>
>><<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.net
>> --
>> Author: Mark Richard
>> INET: mrichard_at_transurban.com.au
>>
>> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>> San Diego, California -- Mailing list and web hosting services
>> ---------------------------------------------------------------------
>> To REMOVE yourself from this mailing list, send an E-Mail message
>> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>> the message BODY, include a line containing: UNSUB ORACLE-L
>> (or the name of mailing list you want to be removed from). You may
>> also send the HELP command for other information (like subscribing).
>>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net

-- 
Cheers,
John Thomas
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Thomas
  INET: oracle_at_toronto.demon.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).