469,312 Members | 2,524 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,312 developers. It's quick & easy.

General LOB Performance Question

Greetings,

I have a client who is using two BLOB columns in two of their tables
for a new database application. I have not had much experience working
with LOB data and wanted to 'pick your brains' as to any general advise
you can give to imporove the performance of these two columns. Max
size is 10 MB. There is only one BLOB in each table.

Currently the BLOB columns are stored in the same tablespace of 32K
page size. Should I put these in a Large tablespace? Any other
thoughts you may have would be greatly appreciated.

Thanks in advance!!!

Martin

Nov 12 '05 #1
2 1684
mghale wrote:
Greetings,

I have a client who is using two BLOB columns in two of their tables
for a new database application. I have not had much experience working
with LOB data and wanted to 'pick your brains' as to any general advise
you can give to imporove the performance of these two columns. Max
size is 10 MB. There is only one BLOB in each table.

Currently the BLOB columns are stored in the same tablespace of 32K
page size. Should I put these in a Large tablespace? Any other
thoughts you may have would be greatly appreciated.


How big are the LOBs usually? If they are generally small, then you could
wrap the LOB in a structured type and take advantage of the buffer pool for
the small, inlined values.

The general recommendation for LOBs is to store them in a file system based
tablespace to take advantage of the operating system's file system cache.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Nov 12 '05 #2
Thanks.

I actually did wind up storing the blobs in their own tablespace on a
filesystem. The blobs are genearally about 1 MB in size but can be up
to 10 MB...

thanks again for the reply!!!

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by jimjim | last post: by
14 posts views Thread by 2mc | last post: by
9 posts views Thread by Michael | last post: by
13 posts views Thread by gmccallum | last post: by
6 posts views Thread by Alex | last post: by
7 posts views Thread by Joe Ross | last post: by
4 posts views Thread by Daniel Loose | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.