[mythtv-users] [mythtv] Database design documentation?
stanb at panix.com
Sun Jan 14 14:17:47 UTC 2007
On Fri, Dec 29, 2006 at 03:46:23PM +1100, Nigel Pearson wrote:
> >>I think this change:
> >>was probably the one you are wrestling with.
> >>Doing mythcommflag --rebuild should recreate
> >>the recordedmarkup values that were deleted.
> >Indeed, running that command seems to have solved the problem,
> >howeer, the
> >link did not lead me to anything but the top of the CVS tree
> You need the bits that wrapped over to the next line.
> File dbcheck.cpp, line 2412.
> >Mind giving me a short synopsis of what this change was?
> Sure. Database schema change 1153 created a new table
> called "recordedseek" and moved all the seek data from
> the table "recordedmarkup" to the new table.
> This was basically a performance improvement.
> Your frontend only knows to look in the old table,
> hence anything to do with the length of, or seeking
> through the recording, was broken.
> Here is the code changeset:
> and here is the change ticket:
A simple "insert into recordedseek select * from recordedmarkup;" seems to
have fixed this problem!
Thanks for the help on this!
Unix is very simple, but it takes a genius to understand the simplicity.
More information about the mythtv-users