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
RSS Feeds that has gone quite
- 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
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
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
- ^ me reading your posts ^
- Posts: 6318
- Joined: 27 Aug 2005, 22:53
- Location: Saint-Petersburg, Russia
- Contact:
Re: RSS Feeds that has gone quite
i think its a button called inactive feeds (looks like the query is in classes/pref/feeds.php, function inactiveFeeds())
Who is online
Users browsing this forum: No registered users and 1 guest