Re: Full Text Search with SAP-DB

> Could you explain your issue more precisely ? I'm not sure to
> understand what you do exactly. In general, the search engine returns
> a ranked list of documents ids and we have to decorate those ids with
> the title and an excerpt of the text to present them to the user is
> that what you use the tmp table for ?

1) For further filtering the full text search results using data only
available in the database. While this data could be duplicated into the
index, this wouldn't always be effective, e.g. for range queries. The
index would have to be updated more frequently. Also, in some cases I
already have the query system set up to use the database, and would just
like to add the full text search option as an additional constraint.

2) The user may decide which fields he wants to have displayed, in the
worst case all matching documents may be downloaded completely. This
would require duplicating all data into the full text index, slowing
down the indexing process.

3) For sorting search results according to user defined criteria,
currently this is not feasable with Lucene if you are working with a
large set of documents.


--
Eric Jain