Bisey wrote:

> Hi,
> As a new Firebird user, I have one major problem. I created an
> Firebird database with 3 tables. Major table has 22 fields and two of
> them are BLOB fields. Anyway, I started posting records to database to
> see how far is DB size is going. After 3000 records (each of them has
> one picture in BLOB field), DB size became 1.76 GB. One picture is
> 76.7 KB. So 76.7 * 3000 = 224 MB approx. How become Firebird generates
> 1.5 GB for text-only data? DB size is important for me, because
> project is coded to hold more than 7000 records.
> Is there any thing to decrease DB size?
> Thanks,
> Can Abdullah Karaca

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 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.

--
Aage J.