Reply to thread

Message

<blockquote data-quote="oscaroo" data-source="post: 970080" data-attributes="member: 137744">Gday.&nbsp;In my family, we've a dedicated media portal machine. It has *drumroll* EIGHT tv tuners plugged into it. (Although only 6 work [1]). We schedule whole sorts of things. To the point where the machine only sleeps an hour or two a day. &nbsp;An example of&nbsp; show we might record is a , say, 4 week special of David Attenborough something - so we schedule it with &quot;Record every time on this channel&quot;. Unfortunately, after the 4 weeks go past, the schedule remains scheduled even though no more David Attenboruough shows are scheduled.Additionally, we have observed that the time elapsed while scheduling or starting a new recording is proportional to the amount of scheduled shows, in more than O<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite25" alt="(n)" title="Thumbs Down&nbsp; &nbsp; (n)" loading="lazy" data-shortname="(n)" />, perhaps O(n^n). &nbsp;Consequently, about every two months I have to manually traverse the &quot;Schedules&quot; section of the Tv Server config while checking the media portal EPG (via the search show title) ... one .. by one .. to remove expired scheduled tv shows.&nbsp;Is there a nice feature built in, or can one be built in, or can someone give me the SQL to query the MySQL to retrieve the schedules for which no entries exist in the EPG, and then remove them?&nbsp;I find that the lag from scheduling a show until the UI returns from having scheduled the show increases from an instant, to a couple of minutes, due to the above accrual of expired schedules.&nbsp;The machine is an i5 3550 with 32gb of ram running on an SSD for the OS and recording to 3.5&quot; hdd internally. Buying a faster machine is not an option (nor is upgrading the CPU)&nbsp;[1] If you buy more than 1 tv tuner card, ensure that each card you buy is from a different manufacturer. Otherwise, you'll run into pain when the manufacturer didn't test their driver to operate with more than 2 cards of their own brand. As a result two of my twin tuners do not work correctly. One works as a single tuner, and the other one is dead in the water - but I keep it as a spare.</blockquote>

[QUOTE="oscaroo, post: 970080, member: 137744"] Gday. In my family, we've a dedicated media portal machine. It has *drumroll* EIGHT tv tuners plugged into it. (Although only 6 work [1]). We schedule whole sorts of things. To the point where the machine only sleeps an hour or two a day. An example of show we might record is a , say, 4 week special of David Attenborough something - so we schedule it with "Record every time on this channel". Unfortunately, after the 4 weeks go past, the schedule remains scheduled even though no more David Attenboruough shows are scheduled. Additionally, we have observed that the time elapsed while scheduling or starting a new recording is proportional to the amount of scheduled shows, in more than O(n), perhaps O(n^n). Consequently, about every two months I have to manually traverse the "Schedules" section of the Tv Server config while checking the media portal EPG (via the search show title) ... one .. by one .. to remove expired scheduled tv shows. Is there a nice feature built in, or can one be built in, or can someone give me the SQL to query the MySQL to retrieve the schedules for which no entries exist in the EPG, and then remove them? I find that the lag from scheduling a show until the UI returns from having scheduled the show increases from an instant, to a couple of minutes, due to the above accrual of expired schedules. The machine is an i5 3550 with 32gb of ram running on an SSD for the OS and recording to 3.5" hdd internally. Buying a faster machine is not an option (nor is upgrading the CPU) [1] If you buy more than 1 tv tuner card, ensure that each card you buy is from a different manufacturer. Otherwise, you'll run into pain when the manufacturer didn't test their driver to operate with more than 2 cards of their own brand. As a result two of my twin tuners do not work correctly. One works as a single tuner, and the other one is dead in the water - but I keep it as a spare. [/QUOTE]

Verification