• Subject: RE: 1 KB GIF takes 4 MB on DB2 ????????
  • From: "Bleddyn Williams" <bleddyn@xxxxxxxxxxxxxxx>
  • Date: Thu, 29 Mar 2001 13:50:43 +0100
  • Importance: Normal

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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.