[mythtv-users] Record only shows which don't exist in the video database

[Thomas Boehm]

----- Original Message -----
> On 04/13/2011 08:20 AM, Thomas Boehm wrote:
> > I try to setup a custom rule which should record movies from certain
> > actors, but only if they don't exist in my video database. The first
> > part is quite easy and works, but I'm struggling with the test
> > whether a movie already exists or not.
> It might work if you do something like:
> 
> ... AND program.title NOT IN (SELECT DISTINCT title FROM
> videometadata)

Thanks so much, it works like a charm.
 
> However, I don't know what effect the subquery will have on
> performance--and if you have a lot of show titles in MythVideo, it may
> be very slow.

I will keep an eye on this. It takes quite a while when saving the rule. It's much faster when I search for the actor in program.description only. But I think I can live with it for now.

Thanks again
Thomas