> 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 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
