RE: 1 KB GIF takes 4 MB on DB2 ????????

["Bleddyn Williams" <bleddyn@xxxxxxxxxxxxxxx>]

Isn't it better to just make the object in the database a field reference link to the object in the IFS (cant remember the field type name)? That way it maintains the referential integrity of the IFS object as you are not supposed to be able to delete it, because a link field exists in the dB?

 

Then you are storing the object in the binary file system which also makes it faster to serve, rather than coming from a BLOB?

Thanks Bleddyn

http://www.ignite400.org - iSeries eBusiness User Group

http://www.morpheus.co.uk - Morpheus - eBusiness Solutions
 

-----Original Message-----
From: owner-web400@midrange.com [mailto:owner-web400@midrange.com]On Behalf Of Kaushal Trivedi
Sent: 29 March 2001 13:35
To: WEB400@midrange.com
Subject: 1 KB GIF takes 4 MB on DB2 ????????

Hi Everybody,

My one KB gif takes up 4MB on db2 where it is stored as a BLOB.

Can anybody explain why and how to avoid such overhead.

 

TIA

Kaush.