[mythtv-users] RecordedSeek Table Size

[Tony Lill]

"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 at every one
second mark 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.
--
Tony Lill,                         Tony.Lill at AJLC.Waterloo.ON.CA
President, A. J. Lill Consultants        fax/data (519) 650 3571
539 Grand Valley Dr., Cambridge, Ont. N3H 2S2     (519) 241 2461
--------------- http://www.ajlc.waterloo.on.ca/ ----------------

Understatement of the century:
"Hello everybody out there using minix - I'm doing a (free) operating
 system (just a hobby, won't be big and professional like gnu) for
 386(486) AT clones"

	- Linus Torvalds, August 1991