RE: blobspaces

Maria Yes there are. When a blob is stored in a regular tablespace, any = changes are logged in the physical and logical log and they are also = brought in through the buffer cache. When a blob is stored in a = blobspace, the physical and logical logging are bypassed and they are = read in/written out directly bypassing the buffer cache. However = blobspaces can be recovered (internally by Informix) in case of failure. A good rule of thumb is to store blobs of size greater than 1 page in = blobspaces. Otherwise using regular tablespaces for large blobs will = result in high swapping in the buffer cache and also requires you to = configure large logical and physical logs. HTH Sujit Pal ---------- From: Maria L. Wilson[SMTP:m.l.wilson@larc.nasa.gov] Sent: Monday, August 11, 1997 2:01 PM To: informix-list@rmy.emory.edu Cc: wilson@cscsun3.larc.nasa.gov Subject: blobspaces What are the advantages of setting up blobs in blobspaces versus a regular tablespace? Is there some performance advantage? Thanks, ----------------------------------------------------- Maria L. Wilson Computer Sciences Corporation NASA Langley Research Center 3217 N. Armstead Ave. Hampton, Va 23666 email: m.l.wilson@larc.nasa.gov phone: 757-766-8265=20 fax: 757-766-2571 -----------------------------------------------------