Re: Searching question

Hege wrote:
> How would someone be able to search through like 1.5 million records
> looking for a specific piece of text in a field without having to do a
> linear search through each record, given the fact that they do not have
> any information about the other fields in the table?
>
> Thanks.
>
> Hege
>

You need to be looking at a text retrieval system if the text length per row is of any appreciable length. If it is short (avg. < 10 "words" per row, say) then a secondary table with each "word" and its row's primary key could be used, probably maintained by an insert and after update trigger. A requirement for left truncation at the word level (LIKE '%search' vs LIKE 'search%') presents more challenges, which may be met by putting both "word" and "drow" in the secondary table. That leaves only double truncation (LIKE '%search%') unaddressed. Received on Thu Jan 19 2006 - 22:41:30 CET