[mythtv-users] sanity check of recorded seek?

Scott & Nicole Harris snharris99 at live.com
Thu Jul 7 22:28:33 UTC 2011

On Thu, 7 Jul 2011, Brian J. Murrell wrote:

> My recordedseek table has 4,975,518 rows in it.  I understand that a
> single recording can produce many rows in this table but still, 5M rows
> seems like much.
> Does anyone have a quickie little mysql statement to test that every one
> of those 5M rows is for a currently recorded/stored program?

This is the one I came up with a few years ago....

SELECT recordedseek.chanid, recordedseek.starttime
FROM recordedseek
SELECT recorded.chanid, recorded.starttime
FROM recorded
WHERE recorded.chanid = recordedseek.chanid
AND recorded.starttime = recordedseek.starttime);

More information about the mythtv-users mailing list