[Rt-devel] R: [Rt-announce] RT 3.9.4 - first development release leading to RT 4.0.0

[Guadagnino Cristiano]

I posted about this in the users mailing list, but since not everybody may be reading both lists I'll repeat it here:

I have finished integrating the Sphinx full-text search engine in RT. We did it on RT 3.8.8.
It is working very well here, and I have published everything on the wiki (look for "IntegrateSphinx").

It may not be the solution you're looking for, but it works VERY well on a mysql database of about 15 thousand tickets.

There are new developments with respect to what I published on the wiki (sortable columns in the results), I'll try to update it ASAP.

Bye
Cris


-----Messaggio originale-----
Da: rt-devel-bounces at lists.bestpractical.com [mailto:rt-devel-bounces at lists.bestpractical.com] Per conto di Jesse Vincent
Inviato: Wednesday, September 29, 2010 8:39 PM
A: Brian Kroth; rt-devel at lists.bestpractical.com
Oggetto: Re: [Rt-devel] [Rt-announce] RT 3.9.4 - first development release leading to RT 4.0.0


On Wed, Sep 29, 2010 at 01:29:38PM -0500, Brian Kroth wrote:
> <snip/>
> 
> > We expect fast full-text searching on Postgres and Oracle, as well some
> > other cool features, to land in RT 3.9 within the next few weeks.
> 
> What about MySQL?  Somewhere (insert link here) I remember reading the
> RT 4.0 was to include a db abstracted FTS feature that even supported
> MySQL w/InnoDB.  Is this being dropped?

It's not a priority right now, since the other database engines include workable built-in full text and we'd need to do 50x (seriously) more work to bundle in an external FTS. We basically have the Pg/Oracle code. MySQL's internal FTS isn't really as useful.

So, "dropped", no. "Backburnered" - definitely.

If you want/need FTS on MySQL, we can certainly chat about how to make that happen.

Best,
Jesse
> 
> Thanks for the hard work,
> Brian
> 
> <snip/>



-- 
_______________________________________________
List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel