RE: What about Blobs?

[qsrvbas@xxxxxxxxxxxx (Tom Liotta)]

midrange-l-request@xxxxxxxxxxxx wrote:

>   3. RE: What about Blobs? (Nathan M. Andelin)
>
>> I guess it has more to do with my own laziness than
>> anything else.
>
>If that's the case, then the choice is clear.  It's easier to upload a PC
>file to an IFS directory than upload into a blob.

I'm not so sure.

The use of CLOBs (I had the impression that CLOBs were appropriate, rather than 
BLOBs) means that DB2 eases a lot of the management. By placing the text into 
multiple stream files, you are taking on a significant management task.

As long as there's _always_ only a single stream file, it's no big deal. But 
when the second one is stored...? Generate new file name? Generate thousands of 
file names as new ones get stored? Track the names in a separate SQL table so 
you know what file names are associated with which text strings? Purge obsolete 
files (and associated table entries)? Manage how many are stored in the 
directory? Multiple subdirectories? ...?

A single SQL table with a CLOB column could be significantly easier.

Tom Liotta

-- 
Tom Liotta
The PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone  253-872-7788 x313
Fax    253-872-7904
http://www.powertech.com



__________________________________________________________________
Switch to Netscape Internet Service.
As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register

Netscape. Just the Net You Need.

New! Netscape Toolbar for Internet Explorer
Search from anywhere on the Web and block those annoying pop-ups.
Download now at http://channels.netscape.com/ns/search/install.jsp