Re: how to find size of blob field in table

Hi
Thanks for the information, You just mentioned there is a way to find out
how big each file is, can you let me know how.
Can find by each row what is the size of that row, so i can estimate exactly
how much difference it will make when we compress pdf vs save it
uncompressed.

Ashish

On Thu, Oct 14, 2010 at 8:05 AM, Charles Wilt <charles.wilt@xxxxxxxxx>wrote:

On Wed, Oct 13, 2010 at 10:45 PM, Ashish Kulkarni
<ashish.kulkarni13@xxxxxxxxx> wrote:

Hi
I have a requirement to identify what will be a size of table if i insert
10000 PDF files in this table,
I have a table with a blob column, and i know the average pdf file size

on

windows is about 25KB,
is it safe to assume the size of this table will be 10000 X 25 = 250000

KB

which is about 244 MB.

There's some additional bytes required, but if you are rounding to an
average KB anyway, then they are insignificant.

I'd say your estimate is good enough.

Is there any accurate way to find this, the table will be in DB2 on

AS400.

Sure, but you'd need to know exactly how big each file is.

Since you don't, I wouldn't bother.

Also if i save these PDF files on IFS folder, does the size to store on

IFS

same as file stored in BLOB?

there'd be a per file/row overhead when you put it in the DB, but
again, it's probably close enough and teh size of teh IFS should be
the same as on Windows.

Is there any software to compress these PDF files for storing and then
uncompress to retrieve?

The PDF format support a built-in compression. How are these PDF's
generated? I'd recommend making sure they are being generated with
compression. Then you don't have to worry about it.

HTH,
Charles
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.