[mythtv] Re: [mythtv-commits] mythtv commits

[David Engel]

On Tue, Jun 01, 2004 at 08:12:18AM -0500, Kevin Kuphal wrote:
> What about using full text searches?  I think these are supported in 
> MYSQL3 (but I could be mistaken) and they're generally pretty fast in 
> matching text compared to a LIKE I believe.

Interesting.  I didn't know about full text searches and patterned the
search rules after the existing search functionality, though I did
consider switching from LIKE to REGEXP.

On one hand, the full text searches could provide the flexibility I'd
hoped to provide with REGEXP, but in a much user friendlier way.  On
the other hand, the "fuzzy" nature of full text searches gives me some
pause over false positives.  I'm also concerned about adding data to
tables with existing full text indexes being slow, think
mythfilldatabase.

I'll try to run some tests this evening, and also wait for Bruce to
chime in on this.

David
-- 
David Engel
gigem at comcast.net