I am trying some experiments. I droped 2 BLOB fields from my DB and it
became from 1.67 GB to 1.72 MB. I guess best way is not storing images
in the DB.

Thanks,
Can Abdullah Karaca

--- In firebird-support@yahoogroups.com, Yves Glodt <yves@s...> wrote:
> 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
> >
> >
> >
> >
> >
> >
> >
> > .
> >