Dear Werner,
I am using BLOB storing tif files and in my case the database size is
not growing although we also update
from time to time a record containing blobs / 2MB-4 MB each.
I did not rebuild the database by gbak / restore for over a year but
the size of the databases was around 1,8 GB and stayed more or less
constant. ( we splitted them into several databases);

I wd not be afraid of the increasing size - and a gfix will NEVER shrnk
the physical size but do a housekeeping and reuse of pages...

If you want more info - contact me privately heeg.c@...

Claus Heeg


superkatchina wrote:

>Hallo,
>
>now I habe another problem. When I store data into a blob-field and
>then I update it with new data again and again, the filesize of the DB
>is exploding suddenly.
>The data-size for importing data was never as big, and at
>exploding-time it was very small. (But I have restarted the DB) It
>seems so, that the DB has a cache, which was written back to Disk.
>
>Now I have a filesize > 60MB what can I do, get a smaller file, or to
>avoid exploding.
>
>Calling gfix -sweep helped nothing.
>Making a backup and restore is producing a small optimized DB-file again.
>
>The problem is, that I will have very many blob-datasets with a lot of
>working on it. And I have fear, that the DB-file will be to lage.
>
>Thank you,
>Werner Hofmann
>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>