[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