Page 1 of 1

RSS Feeds that has gone quite

Posted: 24 May 2016, 22:39
by Striker21
Hi all,

I was hoping someone might already have done something similar MySQL wise optimally and could share.

I was planning to code a maintenance data pull for my internal dashboard that would show me feeds where there's been no entries for e.g. 3 days as to spot potential issues to look further into. However I'm not an MySQL guru and every time I try something my script is timing out (likely as I'm trying to access trrss_entries with some left joins which is about half an million entries big.

If someone is up for the challenge, got the skills to write or already have some maintenance queries like that I'd love if you could share.

Chris

Re: RSS Feeds that has gone quite

Posted: 24 May 2016, 22:58
by fox
i think tt-rss already does this (albeit the period is larger, maybe 30 days? i don't remember), you can fish out that query and copy-paste it somewhere

Re: RSS Feeds that has gone quite

Posted: 25 May 2016, 00:17
by Striker21
Thanks fox, I'll have a look around for it. Is this 30+/- day code somewhere visible or just some code that should be around, can't recall having seen in anywhere view wise...

Re: RSS Feeds that has gone quite

Posted: 25 May 2016, 07:47
by fox
i think its a button called inactive feeds (looks like the query is in classes/pref/feeds.php, function inactiveFeeds())