[mythtv] Question about finding to-be-recorded programs

Geoffrey Hausheer ou401cru02 at sneakemail.com
Fri Jul 11 18:02:41 EDT 2003


On Fri, 11 Jul 2003 14:40:09 -0700, "Anduin Withers
awithers-at-anduin.com |mythtv/1.0-Allow|" <lh7fhh4obx0t at sneakemail.com>
said:
> > In mythbackend appears to determine all the programs it should record
> > from ScheduledRecording::findAllProgramsToRecord.  From my reading of the
> > mySQL query therein, it looks like we always check whether a program has
> > been recorded before, regardless of the recordingtype.
> 
> Are you worried about efficiency? The comparison only results in the new
> "duplicate" field being returned in the query results. It is how the
> results
> of that field are used later that determines the real list. (I think
> PruneList deliberately ignores single records for example, thus not
> applying
> duplicate detection).
Ahh, sounds like I just didn't understand this clearly.  I'm still trying
to wrap my mind around how the 'JOIN' commands modify the query results. 
I think I see what is going on now.  According to the mysql
documentation, the join is only processed after the WHERE, so I guess
this search should be pretty efficient.

Thanks,
.Geoff
-- 
  Geoffrey Hausheer
  XXXXXXXXXXXXXXXXXXXXX


More information about the mythtv-dev mailing list