RSS Feeds that has gone quite

Striker21
Bear Rating Trainee
Bear Rating Trainee
Posts: 42
Joined: 27 Oct 2015, 00:30

RSS Feeds that has gone quite

Postby Striker21 » 24 May 2016, 22:39

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

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: RSS Feeds that has gone quite

Postby fox » 24 May 2016, 22:58

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
Bear Rating Trainee
Bear Rating Trainee
Posts: 42
Joined: 27 Oct 2015, 00:30

Re: RSS Feeds that has gone quite

Postby Striker21 » 25 May 2016, 00:17

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

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: RSS Feeds that has gone quite

Postby fox » 25 May 2016, 07:47

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


Return to “Everything else”

Who is online

Users browsing this forum: No registered users and 2 guests