[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
WHERE NOT EXISTS(
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