Re: Long columns obsolete

On Sun, 07 Dec 2003 13:53:40 GMT, willjamu_at_mindspring.com (James Williams) wrote:

>On Sat, 06 Dec 2003 10:26:55 +0100, Robert <cookie - remove -
>@tref.nl> wrote:
>
>They are deprecated but still used.
>
>ESRI's ARCSDE (worlds premier GIS software) recommends still going
>with LONG even though Oracle Spatial is supported for performance
>reasons. When LOB's perform as well you will see them go away.

LOBs don't have all the LONG limitations and can be stored out-of-line. When correctly implemented LOBs will always outperform LONGs. However, everyone (especially the thirdparty developers creating 'universal' products) is still using LONGs. They'll probably never go away.

--
Sybrand Bakker, Senior Oracle DBA