Re: blobspaces
Maria L. Wilson wrote:
>
> What are the advantages of setting up blobs in blobspaces versus a
> regular tablespace? Is there some performance advantage?
>
> Thanks,
> -----------------------------------------------------
> Maria L. Wilson Computer Sciences Corporation
> NASA Langley Research Center
> 3217 N. Armstead Ave. Hampton, Va 23666
> email: m.l.wilson@larc.nasa.gov
> phone: 757-766-8265
> fax: 757-766-2571
> -----------------------------------------------------
Yes, performance is the main reason to use blobspace. However, you must
plan ahead to set up appropriate blob page size, which cannot be changed
unless dbexport/dbimport is performed. We have observed the performance
difference many many times.
Chao Y. Din