Re: Storing image as BLOB or as file in filesystem?

Lee, If you have images of average sizes of (6k) and your OS Page Size is 2K, I think your OS will need 3 reads in order to obtain the whole image. When using BLOBS you stored them in a BLOPSPACE not in a dbspace, the main difference is the flexibility of specifying the page size in the BLOBSPACE. Having Informix working with the reads, you specify in the BLOBSPACE a page size of 6K, in that way, Informix will need 1 read to retrieve the Informix, Not to mention the CACHE for BLOBS! Regards, Mario Estrada --------------------------------Reply Separator------------------- -----Original Message----- From: Lee Haw, Ong <leehaw@silkroute.com> To: informix-list@iiug.org <informix-list@iiug.org> Date: S'bado 29 de Agosto de 1998 12:10 AM Subject: Storing image as BLOB or as file in filesystem? >Hi, > >I'm working on web project using IUS and have this doubt - what'are the >advantages of storing images (GIF/JPG) in blobspace, over storing in >filesystem? Isn't it more efficient to store in filesystem, as there >will be lesser overhead to retrieve them? > >Thanks, tata. > > >