Bisey wrote:

> Hi,

Hello!

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

DB size is not a problem (if you have the diskspace ;), firebird has no
problem with GB-sized databases.

However, I would suggest to rework your DB and application design and
store the pictures on the harddisk instead of the DB. Store only the
filename in the DB, relative to a path you set in the configuration of
your application, that should be the most solid, and you have to change
only one thing if ever you move your pictures to another place.

Yves

> Thanks,
> Can Abdullah Karaca
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
> .
>