[mythtv-users] re cordedseek table with 800,000 records

[Michael T. Dean]

On 04/03/2008 05:53 PM, Brad DerManouelian wrote:
> mtrax11 wrote:
>   
>> I just had a peek at the recordedseek table has roughly 800k entries is this
>> normal?
>> if not normal can I delete them?
> Only 800k?
>
> mysql> select count(*) from recordedseek;
> +----------+
> | count(*) |
> +----------+
> |  2014695 |
> +----------+
>
> Yes, it's normal. You will have an entry for every few seconds of video 
> you've recorded.

Or, actually, in most cases (at least with MPEG-2), 2 entries per second.

>  This is how Myth knows how to jump around in your 
> video. Quite handy. Do not delete. :)
>   

Unless you want to see just how handy it is.  Note, though, that running
mythcommflag --rebuild or mythtranscode --buildindex (depending on
filetype) individually on every recording you have can take days.  :)

Mike