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

[Kevin Kuphal]

David Engel wrote:

>On Sat, May 29, 2004 at 03:32:42PM -0400, J. Donavan Stanley wrote:
>  
>
>>Couldn't the search based scheduling just be kicked off when 
>>mythfilldatabase runs and when the searches change?  
>>    
>>
>
>I suppose something like this could be done if performance becomes a
>problem.  FWIW, the same could be done for the normal record rules
>too, since the candidate record list should only change if the
>recording type changes.
>
>  
>
>>I'm not sure how 
>>you've implemented this so it may not be possible with your 
>>implementation..
>>    
>>
>
>I originally tried augmenting the main DB query in AddNewRecords, but
>the performance sucked.  Apparently, mysql falls down, when multiple
>LIKEs are used in OR conditions.  It especially doesn't like having
>the credits and people tables in the mix when they aren't actually
>used.
>
>I wound up keeping the previous AddNewRecords query, mostly in tact,
>for the normal rules, then doing an additional query for each search
>rule and merging the results programatically.  In this way, the
>overhead for search rules is only incurred if they are used.
>
>David
>  
>
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.

Kevin