Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Paul Watson — — source: Usenet: comp.databases.informix
Just select length(blob), works fine on text and images AFAIR, it should
be OK on clob but I've never tried.
The alter table is OK but it will be slow.
Andrew Hamm wrote:
>
> Hi folks
>
> I've never used blobs, but now I'm helping to resize and reorganize an
> engine.
>
> How do I get a dump of the sizes of existing blobs used in their live data?
> I want to work out a decent pageunit to use to optimise space and time on
> the bulk of their blobs
>
> thanks in advance.
>
> oh - another Q. Once we've created a blob space, what's the trick (if any)
> for relocating their existing in-table blobs out to a blobspace? Just a
> simple application of the ALTER TABLE command in the expected manner?
--
Paul Watson #
Oninit Ltd # Growing old is mandatory
Tel: +44 1436 672201 # Growing up is optional
Fax: +44 1436 678693 #
Mob: +44 7818 003457 #
www.oninit.com #
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.