Page 1 of 1

Reuse feeds for multiple users

Posted: 15 Mar 2013, 14:26
by julien
Hi,

Using ttrss in multiple users mode, it seems that feeds are not reused, for example each time a user registers, ttrss forum & new releases feeds are added to ttrss_feeds table, and new entries for each feed are added to ttrss_entries.

It may be better to have a single entry for each feed url, and for each entry, as the ttrss_user_entries contain ttrss_entries and ttrss_feeds ids.

This would not only avoid multiple same rows in ttrss_entries id and ttrss_feeds, but also avoid the update daemon the need to fetch new entries several times for the same feed.

What do you think ? I hope I was clear enough :D

Re: Reuse feeds for multiple users

Posted: 15 Mar 2013, 14:31
by fox
Wow, this is so brilliant. Why didn't I ever think of that.

Re: Reuse feeds for multiple users

Posted: 15 Mar 2013, 17:08
by artumirichard
Just in case this isn't clear, fox is being sartcastic.

Re: Reuse feeds for multiple users

Posted: 15 Mar 2013, 17:14
by blainemono
is he really?

Re: Reuse feeds for multiple users

Posted: 15 Mar 2013, 17:15
by fox
I would say fantastic.

Re: Reuse feeds for multiple users

Posted: 15 Mar 2013, 17:20
by julien
So I guess there is a good reason for it being that way, or I missed something.
Can you please tell me Mr Fantastic ?

Re: Reuse feeds for multiple users

Posted: 15 Mar 2013, 17:29
by fox
Not just feed URL is stored there, so I guess it stuck this way. Also, tt-rss started as a single-user app so it wasn't really a problem.

Re: Reuse feeds for multiple users

Posted: 11 Jan 2016, 16:05
by vino4all
I'm not sure whether it has been resolved in the recent version? If not someone please guide me to implement this feature.
-> Fetch entries for unique feeds -> Insert into all users subscribed to the feed

So that I can avoid multiple downloads for the same feed for multiple users. Imagine there are 1 million users subscribed to XYZ feed, then XYZ will get 1 million requests in spite it serves the same data.

Re: Reuse feeds for multiple users

Posted: 12 Jan 2016, 11:20
by fox
the updating process goes by feed url, it downloads something once and uses the cached data for all users' feeds with this url