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

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

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.

This mailing list archive is Copyright 1997-2024 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.