Re: blobspaces

Sujit Pal wrote: > > Chao/Art > > Here is my $ 0.02. > > Also, as both Art and I have stated, BLOBs of 1-2 pages (which are not = > exactly large :-)) would perform better if stored in tablespaces since = > they can take advantage of the buffer cache. However Chao's application = > has BLOBs of sizes 25-40 pages (assuming 1 page =3D 2K). In that case, = > as Chao rightly says the benefits of buffering may be offset by high = > page swapping. > > And thanks Art and Chao for lots of well thought out practical advice. > > Sujit Pal > Hmmm, Considering that a page is either 2 or 4K and if you are storing blobs in table space, are they being stored with the row? Or does the row have a pointer to an offset in a different chunk? I mean this may be a totally brain dead question, but, how does Informix store a blob in "table" space? Also, what happens when the data grows? What happens to the organization of extents? It's been a while since I have looked at blobs so my alzhimers is kicking in. -Mikey -- #include <std_disclaimer.h> /* Mike Segel (MS385) */ #include <No_Spam.h> #ifdef OFFENDED_BY_CONTENT The author takes no responsibility for this post. Any resemblence to a coherent rational thought is purely coincidence. -The Management. #endif ***************************** Due to AGIS's Refusal to Act Responsibly We are blocking all of their domains at the packet level. This block will exist until AGIS modifies their policies to conform to existing RFCs and net community standards. We encourage all ISPs and domain holders to do the same. *****************************