[mythtv-users] RecordedSeek Table Size

[Michael T. Dean]

On 07/24/2007 10:13 PM, Tony Lill wrote:
> "Nick Morrott" <knowledgejunkie at gmail.com> writes:
>> On 24/07/07, Chris Tepe <cstepe at ctdataservices.com> wrote:
>>     
>>> I recently had an issue with the database  where I had to repair the
>>> recordedseek table.   My table is >40 megs and has more than a million
>>> records in it.  Is this normal and should I be concerned.  I'm running
>>> myth .20 on FC4.
>>>       
>> If you have a number of recordings that is entirely possible. I
>> currently have 92 recordings listed in my `recorded` table (majority
>> recorded from ivtv cards) with >400,000 records in `recordedseek`. You
>> should notice that as your net number of stored recordings reduces so
>> does the number of records in `recordedseek`. This table provides seek
>> information for the recorded video streams.
>>     
>
> The database contains the file offset for the frame

Every keyframe

>  at every one
> second mark

Which can occur at different intervals depending upon recorder, but
generally are seen about every 12th or 15th frame (which works out to
about every 1/2 second for PAL (25fps) or NTSC (30fps)).

>  in all your recorded programs, plus a bit of other stuff
> too. So it should be in the neighbourhood of 3600 * number of hours of
> recordings.

Times 2.  :)

Mike