Re: importing images
Posted in 1992
Topics: Performance & Tuning, Connectivity: ESQL/C, 4GL & Embedded SQL
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