Opened 18 years ago
Closed 18 years ago
Last modified 17 years ago
#1865 closed patch (fixed)
Move seek info from recordedmarkup
Reported by: | 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)
Change History (4)
Changed 18 years ago by
Attachment: | recordedseek.diff added |
---|
Changed 18 years ago by
Attachment: | recordedseek.2.diff added |
---|
Minor change, don't drop offset column yet for backwards compatability
comment:1 Changed 18 years ago by
Resolution: | → fixed |
---|---|
Status: | new → closed |
comment:2 Changed 17 years ago by
(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
Patch