We've got a table with a BLOB column that is currently at 3+ Gig (400,000 records). The max value in the BLOB column is 3k (average (1.5 K). We are currently
storing the BLOB "out of line" (in a separate tablespace). The cache size
for the BLOB is 8k (also the block size). Each BLOB is taking up 8K (at
the least twice the space required by the BLOB). This table is expected
to grow to 10+ million records in the next year.
First of all, we're trying to convince the vendor to agree to partition
the table.
In addition (FINALLY the question :-) !!!), we're trying to decide
whether we would gain anything (space being a constraint right now),
from a storage standpoint in making the BLOB "in line".
Obviously we're not going to going to risk performance in order to save
space :-) !!!
I'm hoping someone in this list would have had some goog or bad
experience in this regard. Would there be a major performance hit if I
change
the BLOB to be "in line" ????
Thanks,
Sunny
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site
