Reply to thread

Message

<blockquote data-quote="JDWestoby" data-source="post: 1121311" data-attributes="member: 72093">Right-oh.Deleting channels makes more sense because it stops the database getting full of kruft. With any database smaller will always be faster/better (OK, not a massive issue as my C: is an SSD. Timeshifting folder is on a 5GB SuperSpeed RAMDisk, so I do try to optimise.)Unticking/Moving them would not achieve that (although perfectly valid in themselves).Basically if I could have a 'blacklist'* of channels (and I'm not saying this has to be part of TV Server) so that they could be binned it would mean that a scan wouldn't put a lot of channels I don't want.Just the way MP says delete encrypted (because I can't see them) it would be nice to be able to bin those I KNOW I don't want!(*Obviously a whitelist makes no sense - I'd never get to see any new channels.)I am impressed by the answer/responses though - if nothing else it shows that it has made people think about how to work around this.Give me an SQL command that won't stuff up the TV Server database and I'd be happy <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite8" alt=":D" title="Big Grin&nbsp; &nbsp; :D" loading="lazy" data-shortname=":D" />, after all I have to scan from Windows.(Actually for the last two months the MP PC has been running a server system only - stopped the TV cards from crashing it too!)</blockquote>

[QUOTE="JDWestoby, post: 1121311, member: 72093"] Right-oh. Deleting channels makes more sense because it stops the database getting full of kruft. With any database smaller will always be faster/better (OK, not a massive issue as my C: is an SSD. Timeshifting folder is on a 5GB SuperSpeed RAMDisk, so I do try to optimise.) Unticking/Moving them would not achieve that (although perfectly valid in themselves). Basically if I could have a 'blacklist'* of channels (and I'm not saying this has to be part of TV Server) so that they could be binned it would mean that a scan wouldn't put a lot of channels I don't want. Just the way MP says delete encrypted (because I can't see them) it would be nice to be able to bin those I KNOW I don't want! (*Obviously a whitelist makes no sense - I'd never get to see any new channels.) I am impressed by the answer/responses though - if nothing else it shows that it has made people think about how to work around this. Give me an SQL command that won't stuff up the TV Server database and I'd be happy :D, after all I have to scan from Windows. (Actually for the last two months the MP PC has been running a server system only - stopped the TV cards from crashing it too!) [/QUOTE]

Verification