From: Pierre Baillet <oct@...>
Date: 2002-10-08T03:22:30+09:00
Subject: Re: Freetext search (was: iowa)

Good evening,


On Tue, Oct 08, 2002, Dave Thomas wrote:
> 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 can do this on my namazu install which indexes all my mail:

 ./namazu +from:dave  matz python head ~/namazu/

to get all your mails which talk about matz and python.

namazu is pretty straightforward to install and allows one step of url
rewriting to link to a custom document from the search result page.

hth,
-- 
Pierre Baillet
          Support the Debian GNU/Linux Project (http://www.debian.org)