--- In firebird-support@yahoogroups.com, 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.

Adam