Thanks for the tips!

>> When I need sorting on blobs, I extract and
>> store keywords from the client side when
>> inserting blob data.

I can't really do this because many clients will be contributing data.
But I suppose I can keep a second VARCHAR field that is a truncated
version of the BLOB. Of course, as I understand it, this would have to
be pretty small in order to be usable for indexing. I could have
hundreds of thousands of these, so I don't know if a row scan without an
index is feasible.

R.

-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Tuesday, March 25, 2003 1:54 PM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Sorting and Searching BLOB SUB_TYPE 1 fields


At 08:45 AM 25/03/2003 -0800, you wrote:

>I'm using Java + Firebird. I have some text fields that cannot be

bounded

>by size and I'm wondering how I can efficiently sort or search on those

fields.

For searching, you *can* use CONTAINING on blob sub_type 1.

You can't index or sort blobs. When I need sorting on blobs, I extract
and
store keywords from the client side when inserting blob data. When the
text is e.g. a document of a set layout, this might be as simple as
storing
the title in an indexed column. If you need multiple sorts, you can add

more structure and store other data relating to the blob content.

heLen



Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.