By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,396 Members | 2,501 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,396 IT Pros & Developers. It's quick & easy.

table with BLOB impact database performance?

P: n/a
mjf
Hello,

I have a table in the database that has a BLOB field to store images,
which is usually more than 1MB per record. There are currently near
9000 records in it, which means the table is growing to be huge. Will
this slow the database performance significantly? If so, how to reduce
the image size? Does DB2 provide a way to compress a column data?

Thanks.

Jun 23 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
mjf wrote:
I have a table in the database that has a BLOB field to store images,
which is usually more than 1MB per record. There are currently near
9000 records in it, which means the table is growing to be huge. Will
this slow the database performance significantly? If so, how to reduce
the image size? Does DB2 provide a way to compress a column data?

Isn't your image already compressed (e.g. JPEG).
Compressing a compression typically is very ineffective.
You can also use commonly available compression routines and wrap them
in a UDF.
E.g. (first thing I found on Google):
http://www.oberhumer.com/opensource/ucl/

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Jun 23 '06 #2

P: n/a
mjf
Thanks for the reply and info! The images are NOT already compressed,
and they are bmp files. They are now considering to compress the images
before storing them in DB2.

Serge Rielau wrote:
mjf wrote:
I have a table in the database that has a BLOB field to store images,
which is usually more than 1MB per record. There are currently near
9000 records in it, which means the table is growing to be huge. Will
this slow the database performance significantly? If so, how to reduce
the image size? Does DB2 provide a way to compress a column data?

Isn't your image already compressed (e.g. JPEG).
Compressing a compression typically is very ineffective.
You can also use commonly available compression routines and wrap them
in a UDF.
E.g. (first thing I found on Google):
http://www.oberhumer.com/opensource/ucl/

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/


Jun 23 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.