Re: [GENERAL] Full Text Searches

We have a fulltext stuff in the contrib directory.


> On Sun, 23 May 1999, Andy Lewis wrote:
> 
> > Whats the possibility of having full text searches added to text fields?
> > 
> > That would be awesome.....
> 
> Unfortunately, full text indexing is a different issue than the kind of
> indexing performed on table columns, and if you want to do any kind of
> efficient full text searching, you have to index the individual words in
> the text or it'd be so slow as to be hardly useful (especially if you're
> talking about 600,000 records with 2K of text in each text field).
> 
> Excalibur, for instance, creates its own internal indexing for full text
> records, but uses an underlying SQL database for regular fielded data, and
> when you design your database, you have to make the distinction about what
> kind of indexing you want, stop words (words you don't want indexed, like
> 'the' and 'of'), and the way certain fields can or will be searched.
> 
> Brett W. McCoy           
>                                         http://www.lan2wan.com/~bmccoy/
> -----------------------------------------------------------------------
> The six great gifts of an Irish girl are beauty, soft voice, sweet speech,
> wisdom, needlework, and chastity.
> 		-- Theodore Roosevelt, 1907
> 
> 
> 
> 


-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026