Re: Images in Online database

It depends on whether you want the database to control the data in the blobs, on whether you want transactions (commit, rollback -- especially rollback) to apply to them, and on whether it matters that when you archive (or export) your OnLine system, not all the data is backed up. If the answer to any of these is "yes, it matters", then use blobs. Otherwise you can choose to use files, though I'd still use blobs. If they are all very small, you can probably use in table blobs rather than a special blobspace. You wouldn't be wanting a larger-than-standard blob page size if they are all small (meaning smaller than 1 page). Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> >From: cljohns@ibm.net (Claude Lyn Johnson) >Date: 15 Jun 1995 00:43:53 GMT >X-Informix-List-Id: <news.14688> > >Can any one tell me if it is more efficient to store large amounts of small images as BLOB >type in the Online database or is better to store as numbered files in the Unix file system >and use the database on as a lookup tool. > >thanx:-) >Lyn