--- In firebird-support@yahoogroups.com, Aage Johansen <aagjohan@o...>
wrote:

> Did you just load picture files into the blob fields, or did some your
> program do some conversion (e.g. to bmp)? Did you anything else?
> Do a backup+restore and see if database size changes.

I did it, but it just changed less than 100 MB. DB size became 1.55 GB
something. I am just loading jpg pictures to these two fields. There
is no conversion.

> I have a 500MB database containing more than 12.000 pictures (jpg).

The

> sizes varies between 1.5KB and 640KB. If I sum the size of all the
> pictures I get about 400MB.
> However, I usually store pictures outside of the database.

In previous mail, I wrote that I dropped two BLOB fields which store
images and DB became 1.72 MB only for 3000 records. So I guess, it
best to store images outside of the database, however those images are
not more than 100 KB and they are usually 40-50 KB.

Can Abdullah Karaca

> --
> Aage J.