FullText Searching: The Dilemma

[Jeffrey Hulten]

An alternative, while ugly, is writing your own tokenizer and  
implementing search internal to Bugzilla.  It does solve the  
multiplatform issue.


On Jun 25, 2007, at 10:12 PM, Max Kanat-Alexander wrote:

> On Mon, 25 Jun 2007 20:55:48 -0700 "Benton, Kevin"
> <kevin.benton at amd.com> wrote:
>> I'm sure this may have been discussed before, however, I don't see  
>> any
>> reason why we can't split the bugs table into non-text fields stored
>> using InnoDB and a separate bugs_more table that holds text fields
>> stored in MyISAM.
>
> 	Yes, I've considered that. I'm against it ecause only MySQL
> needs that, and I don't want to have this extra table in there for
> every DB just because MySQL has this limitation.
>
> 	Also, that doesn't solve the other problems.
>
> 	Basically, it just doesn't sound to me like an architecturally
> ideal solution.
>
> 	-Max
> -- 
> http://www.everythingsolved.com/
> Competent, Friendly Bugzilla Services. And Everything Else, too.
> -
> To view or change your list settings, click here:
> <http://bugzilla.org/cgi-bin/mj_wwwusr?user=jeffh@tragicallyleet.com>