Subject Re: FireBird .FDB file size won't go down even after deleting a large number of
Author Adam
--- In, Hari Kolasani
<hpkolasani@y...> wrote:
> Thanks Adam.
> I'll try adding some indexes and see how it goes.
> I have around 300,000 rows with four blob columsn that
> store XML documents. I think the reasoning behind the
> size makes sense now.

Well it is possible that 300000 x 4 XML documents would get quite
large. XML is generally quite compressable so you may want to
compress it prior to storing.

You will not be able to index a BLOB field, but certainly any non
BLOB field you need to search on in a regular basis should have
supporting indices.