In need of BLOB expertise 
Author Message
 In need of BLOB expertise

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.



Wed, 18 Jun 1902 08:00:00 GMT
 In need of BLOB expertise

Quote:

>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




Wed, 18 Jun 1902 08:00:00 GMT
 In need of BLOB expertise



Quote:

>>Hello gurus!

  hi!

Quote:
>>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.

Quote:

>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.

Quote:
>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



--
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



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. USA/MA -- Programmer/Analyst Needed for Prestigious Firm - C, SQL, UNIX, PC/GUI, RDBMS Expertise Needed

2. USA/MA -- Programmer/Analyst Needed for Prestigious Firm - C, SQL, UNIX, PC/GUI, RDBMS Expertise Needed

3. Question fro the expertise....SQL server 7.0 Replication Expertise

4. Financial Expertise Needed, SQL Server

5. OLAP Expertise Needed - Chicago Area - Permanent Position

6. JOB: Microsoft needs your SQL server expertise in Redmond, WA

7. need analysis services and mdx expertise (newbie)

8. SQL Server 7 expertise needed please

9. Visual Basic expertise needed in the UK

10. Java server expertise needed

11. TopLink expertise needed !!!


 
Powered by phpBB® Forum Software