Re: In need of BLOB expertise

Kate_Tomchik@homedepot.com wrote: > > > > > >Hello gurus! >We have an application that will be storing blobs on one table. The >average blob size will be 300 K (not counting Informix overhead for storage >of the blob). The system using these blobs is OLTP. SO, based on your >expert opinions, should the blobs be stored with the table in the >tablespace, or in their own blob space? > >Could someone give me a detailed list on the pros and cons of each? I find >the sections of the manual on this topic to be sketchy. > > We scan 250 to 300 checks per day into an Informix 5.x table using SCO Unix. The average size of each blob is only about 35K. I tested having the blobs both in the tablespace and in a separate blobspace. I found that the tablespace blobs gave us better insert and query performance. The downside of this is that your Online buffers will get filled with blobs and not be as effective for other queries. However, in our case, our other applications were not affected. ___________________________________________________________ Jay Aymond United Life & Annuity Insurance Company Email: jay@ulife.com