[mythtv] Re: PATCH: mythfilldatabase v1.43 -- arbitrary end times

Bruce Markey bjm at lvcm.com
Mon Mar 3 11:46:20 EST 2003

Isaac Richards wrote:
> On Monday 03 March 2003 06:45 am, J wrote:
>>Yes, however when I was experimenting with the algorithm,  I found that the
>>batch file to create the temp databases,  was both faster and less memory
>>intensive.  Since this approach needs to have the entire program database
>>indexed,  doing that without the temp databases would mean that the whole
>>program database would have to be read into memory, indexed, and then,
>>rather than doing comparisons on the very small subset of entries (in
>>temp2), you would end up reviewing all the entries. For example, my program
>>database has 17603 records, but temp2 only contains 465.  Since mysql is
>>already optimized for this sort of operation, it seemed the most efficient
>>and elegant solution.
>>That being said,  is it the use of the temp tables, the batch file, or both
>>that you find objectionable?
> The batch file.  But, why would you need the entire database for this?  Seems 
> like it'd be pretty simple to just make an internal list of programs you 
> didn't have endtimes for on a per-day basis (should be one per channel), and 
> then just hit the db for the all next programs' start time once the next day 
> has been populated.

If mythfilldatabase started from the last day then worked
back the current date, the post-midnight endtimes could be
filled in immediately.

--  bjm

More information about the mythtv-dev mailing list