Bisey wrote:

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

Yes, and if you want to reduce your DB size (that is reclain the unused
space) after you dropped the blobs, make a backup followed by a restore.

Regards,
Yves

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