Re: importing images

}From: uunet!desktalk.com!eric (Eric Lieber) }Message-Id: <1992Sep29.181725.1158@desktalk.desktalk.com> }Subject: Re: importing images }Date: 29 Sep 92 18:17:25 GMT }Organization: Desktalk Systems Inc. }In article 1723@execnet, "clay irving" <clay.irving@execnet.com> () writes: }>Does anyone have any experience in getting an image into the OnLine }>database? I'll have a GIF, JPEG or BMP image in a file on the system that }>I want to import into a field defined as a BLOB. I'm wondering how to get }>it into the database?... }> }>=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- }>Clay Irving Work: clay@garpac.com }>4GL Project Manager Fun: clay.irving@execnet.com }>Garpac Corporation uucp: {uupsi3, 4gen}!garpac!clay }>Voice: 212.760.0070 CIS: 75170, 107 }>Fax: 212.564.2635 IBM: HONE82(DACK0AX) }>---------------------------------------------------------- }> * Software Systems for the Apparel Industry * }>=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- } Instead of storing these huge amounts of data inefficiently in the database, }why not store the address (pathname) in the database and keep your GIF/RASTER >file as an operating system file. This will improve performance. }If the picture has to be swapped out with another all u have to do is }update the pathname and you are ready to go. }eric lieber }DeskTalk Systems }Torrance, CA Uh-Uh!! Mr. Lieber, this is true ONLY if you have Informix-SE. If you have OnLine, why not take full advantage of storing these images along with the character data? Why have image files on the slow UNIX file system and the data in the faster raw disk? Now imagine 30,000 scanned customer signatures in a UNIX directory... I can't find ANY reason for doing what you say! +--------------------+--------------------------------------+----------------+ | Eric C. Leschhorn | MICROCOMPUTOS Fax:(809)688-6044 | | | Marketing Director | Dominican Republic Tel:(809)530-8506 +-----------+ | | uunet!microc!eric | Puerto Rico, USA Tel:(809)250-8789 +---------+ | | +--------------------+--------------------------------------| +-+ | | | | I N F O R M I X L A T I N A M E R I C A N T E A M | | | | | | +-----------------------------------------------------------+---+ +---+ +----+