473,406 Members | 2,293 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

table with BLOB impact database performance?

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
2 3092
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Corrine | last post by:
Hi, I am creating a global temporary table that is session-specific. I insert a BLOB into this table, and then select the BLOB from this table into a ResultSet. The ResultSet sees this BLOB...
0
by: Vladimir Kanovnik | last post by:
I have table with columns id(number), photo(blob) and thumbnail(blob). I would like to insert image (using stored procedure) from file to column photo and in same time copy reduced image to column...
8
by: Greg | last post by:
Hello, I've to manage many 'table' (having same scheme) on the same server. And I ask myself what could be the best to do (and if you know, why) : Creating as many database (the name would...
7
by: Warren Wright | last post by:
Hello, We maintain a 175 million record database table for our customer. This is an extract of some data collected for them by a third party vendor, who sends us regular updates to that data...
3
by: Stanley Sinclair | last post by:
(Minor question. Since updating to FP4 I cannot access HTML help. Compiler error. What's wrong?) _______________________ Subject of this message: There is lots of Help regarding getting...
3
by: KR | last post by:
Hi, One of our third-party software vendors is planning to implement BLOB in their database for storing certain documents. We are not too thrilled about it, since it can be a drain on our...
6
by: Kyle Teague | last post by:
What would give better performance, serializing a multidimensional array and storing it in a single entry in a table or storing each element of the array in a separate table and associating the...
7
by: greywire | last post by:
So I need to load lots of data into my database. So I discover LOAD DATA INFILE. Great! This little gem loads my CSV in blazing times (compared to parsing the file and doing INSERT for each...
10
by: eholz1 | last post by:
Hello Members, I am setting up a photo website. I have decided to use PHP and MySQL. I can load jpeg files into the table (medium blob, or even longtext) and get the image(s) to display without...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.