Blob Sizes

Posted in 2000

Vickey Crouch — Thu, 30 Mar 2000 11:50:10 -0600 — source: Informix-list mailing list archive (1991-1998)

Hello, All, Does anyone have a shell script that reports the blob sizes of each blob column for a particular database? I'm in the process of migrating some databases to a new platform, and I'd like to create some blob spaces but I don't know how big the average blobs are.

↪ replying to Vickey Crouch

Stefan Weideneder — Thu, 30 Mar 2000 21:51:47 +0100 — source: Informix-list mailing list archive (1991-1998)

Vickey Crouch wrote: > > Hello, All, > > Does anyone have a shell script that reports the blob sizes of each blob > column for a particular database? I'm in the process of migrating some > databases to a new platform, and I'd like to create some blob spaces but > I don't know how big the average blobs are. Hi, I guess it would be easier to write a small ESQL/C program. Regards -- Stefan Weideneder Phone: +49 89/3565478-2 --------------- --- Fax: +49 89/3565478-3 ------------- ------ mailto:/stefan@weideneder.de --- -------- http://www.weideneder.de -----

↪ replying to Vickey Crouch

Art S. Kagel & Family — Fri, 31 Mar 2000 17:23:31 -0500 — source: Informix-list mailing list archive (1991-1998)

Vickey Crouch wrote: > > Hello, All, > > Does anyone have a shell script that reports the blob sizes of each blob > column for a particular database? I'm in the process of migrating some > databases to a new platform, and I'd like to create some blob spaces but > I don't know how big the average blobs are. SELECT AVG(length( blob_colname )) FROM blob_tablename; I'm not sure you can do the function( function()) but if not use a temp table and average the records there. -- Art S. Kagel & Family kagel@erols.com