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

[David Engel]

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
-- 
David Engel
gigem at comcast.net