Re: blobspaces

There's a slight performance advantage, but the main differences are thus: 1. You can have a different page size for each blob space, to match the approximate size of the data (e.g. If you were storing 1MB images, it would require 500 operations if the page size were 2048 (the default) bytes; and the appropriate number of locks, etc. would be required). 2. Changes to blob pages are not written to the logical logs, and can thus prevent the logs from filling up too quickly. However, you cannot, thus, "roll back" changes to blobs, restore them since the last level 0 backup, or replicate them to another machine. (This accounts for most of whatever performance advantage exists). 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 > -----------------------------------------------------