Re: In need of BLOB expertise
In article <6c48mk$jg6@bgtnsc01.worldnet.att.net>, Jay Aymond <jay@ulife.com> writes >Kate_Tomchik@homedepot.com wrote: > >> >>Hello gurus! hi! >>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. >> In tablespace:- - blobs pass through BUFFERS and are hence cached In blobspace - Blob page size configurable to ensure blobs are stored contiguously - Blobs are not cached, hence do not push other data out of the cache. >> > >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 35K is very small for a blob. Kate, with 300K blobs I would expect that unless you have lots of memory for caching that using blobspaces would be better. >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 -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care