[mythtv] Recordings are starting late

[David Engel]

On Mon, Mar 15, 2004 at 12:08:26AM -0600, Robert Kulagowski wrote:
> Here's some debug information with the patch applied:
> ...
> 2004-03-14 23:33:00 Found changes in the todo list.
> 2004-03-14 23:33:00 after FillEncoderFreeSpaceCache.
> 2004-03-14 23:33:00 after PruneOldRecords.
> Input #0, mpeg, from 
> '/var/myth/video/1047_20040314231200_20040314233300.nuv':
>   Stream #0.0: Video: mpeg2video, 720x480, 29.97 fps
>   Stream #0.1: Audio: mp2, 48000 Hz, stereo, 384 kb/s
> 2004-03-14 23:34:37 after AddNewRecords.

This is kind of what I expected.  The DB queries in AddNewRecords
aren't the most efficient.  That can be improved with some other DB
changes.  Still, I suspect the bigger cause of the delay is DB
contention because of the just ended recording.

FYI, I was able to reproduce the problem myself late last night,
though not to the same degree as you (I get a much smaller delay).
I'm going to look at it tonight.  If it turns out to be DB cotention,
I'm not sure what can be done.

On Sun, Mar 14, 2004 at 11:56:44PM -0800, Bruce Markey wrote:
> can take 15sec to over a minute to start the second. The longer
> the first show, the longer the delay.

This is partly why I'm suspecting a DB problem.  The longer the show,
the larger the recordedmarkup table.

David
-- 
David Engel
gigem at comcast.net