RSS Feeds that has gone quite

[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

[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

[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...

[fox]

i think its a button called inactive feeds (looks like the query is in classes/pref/feeds.php, function inactiveFeeds())