Opened 13 years ago

Closed 13 years ago

Last modified 13 years ago

#1865 closed patch (fixed)

Move seek info from recordedmarkup

Reported by: stuart@… Owned by: Isaac Richards
Priority: minor Milestone: unknown
Component: mythtv Version: head
Severity: medium Keywords:
Cc: Ticket locked: no

Description

The attached patch moves seek related information from recordedmarkup into a new table recordedseek.

It also reorders the primary key so that querying the two tables should be faster.

Lastly the fixes from ticket #1854 are rolled into the patch as they overlapped anyway.

Attachments (2)

recordedseek.diff (7.8 KB) - added by stuart@… 13 years ago.
Patch
recordedseek.2.diff (7.8 KB) - added by stuart@… 13 years ago.
Minor change, don't drop offset column yet for backwards compatability

Download all attachments as: .zip

Change History (4)

Changed 13 years ago by stuart@…

Attachment: recordedseek.diff added

Patch

Changed 13 years ago by stuart@…

Attachment: recordedseek.2.diff added

Minor change, don't drop offset column yet for backwards compatability

comment:1 Changed 13 years ago by Isaac Richards

Resolution: fixed
Status: newclosed

(In [10536]) Move seek tables to 'recordedseek'.

Closes #1865.

comment:2 Changed 13 years ago by Janne Grunau

(In [12823]) Optimizes size of the recordedseek, recordedmarkup and filemarkup table.

Use 64 bit int for offset saves for most recordings space and the fixed size records have a speed advantage. The new size of the mark column limits the maximun recording length to 77 hours at 60fps.

Removes long long to string conversions from position and cutlist map handling.

Attention: The DB schema update can take a couple minutes and needs enough free space on the database partition (depending on the type and number of recordings).

This updates saves more than 25% space for my mythconverg.

Refs #1865

Note: See TracTickets for help on using tickets.