[mythtv-users] RecordedSeek Table Size
Tony Lill
ajlill at ajlc.waterloo.on.ca
Wed Jul 25 02:13:33 UTC 2007
"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
More information about the mythtv-users
mailing list