I think the best software is Rubicon 2 from http://www.tamaracka.com/


Regards,

Nols Smit

----- Original Message -----
From: "dcabbar" <dcabbar@...>
To: <firebird-support@yahoogroups.com>
Sent: 02 January, 2004 12:36 PM
Subject: [firebird-support] Re: Full-text Search Support


> Could you please point out any commercial tools that you can recommend?
>
> Thanks again...
>
> --- In firebird-support@yahoogroups.com, Aage Johansen <aagjohan@o...>
> wrote:
> > On Wed, 31 Dec 2003 11:52:48 +0000 (UTC), dcabbar wrote:
> >
> > > Actually, what I really want is the full-text search portion, and
> > > fuzzy match is just the part of it. i.e. searching for a specified
> > > word in a varchar column. And, as you know using "like %word%" is
> > > pretty expensive.
> > > So, is there at least any add-on that is available? Any
> > > ideas/comments/experience on this?
> >
> >
> > There are commercial tools for this. Also, if you are using IBO you
> can
> > use the facilities there (available as a separate component set). Text
> > search has been discussed on these NG's, and not long ago someone
> said he
> > might consider making his solution available (commercial, I believe).
> >
> >
> > Sometime in 2002, Art Metz wrote a paper on his experiences,
> concluding with
> > <<
> > I suspect that the combination of Rubicon, the TIBO* components, and
> > InterBase would work fine for a text database with relatively
> infrequent
> > changes (say, one insert per second). This is a very common
> scenario, as
> > exemplified by Web searches on Yahoo and databases of newsgroup
> > archives. In these circumstances, Rubicon is an easy way to get
> complex
> > search capabilities to work quickly.
> > However, in my project, the combination failed completely. I spent
> seven
> > workdays trying to get anything to work. Even then it worked badly
> and the
> > overhead was unacceptable. In contrast, the home-grown search
> technique
> > took only one day to implement and works fine.
> > >>
> >
> > YMMV ...
> >
> >
> > It would be great if some "word indexing feature" were included in
> > Firebird. A similar feature in dbISAM seems to work fine, and takes
> much
> > of the tedium out of the work.
> >
> > I'm using a homegrown system in an Fb database, but it took some
> work to
> > get it going. I don't really like to do much programming parsing
> strings
> > etc. in char/varchar/blob in SP's and are therefore doing some of
> the work
> > on the client. This doesn't make for very snappy response over slow
> > connections (e.g. Internet).
> >
> >
> > --
> > Aage J.
>
>
>
>
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to:
> http://docs.yahoo.com/info/terms/
>
>