From: Dave Thomas <Dave@...>
Date: 2002-10-08T03:15:56+09:00
Subject: Re: Freetext search (was: iowa)

Nat Pryce <nat.pryce@b13media.com> writes:

> Why are you using MySQL?  If it's just to index articles by article
> numbers, then you might be better off storing the FAQ in plaintext files
> named by article number.  If lookup performance is too slow, use a
> filesystem that is designed to lookup filenames in huge directories very
> fast, such as ReiserFS.  You can then use normal file system tools to
> search the text, or map the text files into memory, etc. etc.

Something I'd like is queries such as

  article contains:  +matz +irb -python

I know I can do this using egrep n times and combining the results,
but I'd really rather not.

I've tried Glimpse, but I currently can't get 'and' searches to
work. I've also tried Swish, but it's currently segfaulting on me if I
just index a single file...


Cheers


Dave