Reuse feeds for multiple users

Development-related discussion, including bundled plugins
julien
Bear Rating Trainee
Bear Rating Trainee
Posts: 5
Joined: 15 Mar 2013, 14:17

Reuse feeds for multiple users

Postby julien » 15 Mar 2013, 14:26

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

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

Re: Reuse feeds for multiple users

Postby fox » 15 Mar 2013, 14:31

Wow, this is so brilliant. Why didn't I ever think of that.

artumirichard
Bear Rating Trainee
Bear Rating Trainee
Posts: 1
Joined: 15 Mar 2013, 17:01

Re: Reuse feeds for multiple users

Postby artumirichard » 15 Mar 2013, 17:08

Just in case this isn't clear, fox is being sartcastic.

User avatar
blainemono
Gaping Anus of Eternity
Gaping Anus of Eternity
Posts: 246
Joined: 05 Jun 2009, 18:13

Re: Reuse feeds for multiple users

Postby blainemono » 15 Mar 2013, 17:14

is he really?

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

Re: Reuse feeds for multiple users

Postby fox » 15 Mar 2013, 17:15

I would say fantastic.

julien
Bear Rating Trainee
Bear Rating Trainee
Posts: 5
Joined: 15 Mar 2013, 14:17

Re: Reuse feeds for multiple users

Postby julien » 15 Mar 2013, 17:20

So I guess there is a good reason for it being that way, or I missed something.
Can you please tell me Mr Fantastic ?

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

Re: Reuse feeds for multiple users

Postby fox » 15 Mar 2013, 17:29

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.

vino4all
Bear Rating Trainee
Bear Rating Trainee
Posts: 1
Joined: 11 Jan 2016, 15:58

Re: Reuse feeds for multiple users

Postby vino4all » 11 Jan 2016, 16:05

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.

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

Re: Reuse feeds for multiple users

Postby fox » 12 Jan 2016, 11:20

the updating process goes by feed url, it downloads something once and uses the cached data for all users' feeds with this url


Return to “Development”

Who is online

Users browsing this forum: No registered users and 0 guests