DB Article Duplication

Support requests, bug reports, etc. go here. Dedicated servers / VDS hosting only
TSM
Bear Rating Trainee
Bear Rating Trainee
Posts: 13
Joined: 03 Nov 2015, 16:20

DB Article Duplication

Postby TSM » 03 Nov 2015, 16:56

I have recently migrated from Feed-On-Feeds which served our purposes for a long time and had many updates done to support our needs fixing some performance issues.
One of the things I found fairly useful was that articles were not duplicated within the database if many users were subscribed to the same article.
It seems that TTRSS does duplicate them even though though the user_entities it has the possibility for linking back to the same original article. Is this an oversight/problem or that the code has not reached that point yet.

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

Re: DB Article Duplication

Postby fox » 03 Nov 2015, 17:57

deduplication is done based on article guids

so basically depends on your feeds

TSM
Bear Rating Trainee
Bear Rating Trainee
Posts: 13
Joined: 03 Nov 2015, 16:20

Re: DB Article Duplication

Postby TSM » 03 Nov 2015, 19:20


JustAMacUser
Bear Rating Overlord
Bear Rating Overlord
Posts: 373
Joined: 20 Aug 2013, 23:13

Re: DB Article Duplication

Postby JustAMacUser » 03 Nov 2015, 19:40

Do keep in mind that different users can apply different plugins which could result in different article content. One user might use the Readability plugin, another might not; therefore the content would be different for the same article. This type of thing needs to be taken into consideration.

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

Re: DB Article Duplication

Postby fox » 03 Nov 2015, 19:49

your patch is bad, op

e: you can obviously change whatever just pls don't ask me to merge your broken stuff in trunk

TSM
Bear Rating Trainee
Bear Rating Trainee
Posts: 13
Joined: 03 Nov 2015, 16:20

Re: DB Article Duplication

Postby TSM » 03 Nov 2015, 20:02


TSM
Bear Rating Trainee
Bear Rating Trainee
Posts: 13
Joined: 03 Nov 2015, 16:20

Re: DB Article Duplication

Postby TSM » 03 Nov 2015, 20:02


JustAMacUser
Bear Rating Overlord
Bear Rating Overlord
Posts: 373
Joined: 20 Aug 2013, 23:13

Re: DB Article Duplication

Postby JustAMacUser » 03 Nov 2015, 20:12


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

Re: DB Article Duplication

Postby fox » 03 Nov 2015, 20:44


TSM
Bear Rating Trainee
Bear Rating Trainee
Posts: 13
Joined: 03 Nov 2015, 16:20

Re: DB Article Duplication

Postby TSM » 03 Nov 2015, 20:47


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

Re: DB Article Duplication

Postby fox » 03 Nov 2015, 20:48

> we store about 1 years worth of feeds,

lmao

> I can look into the code required to make this all possible.

no thanks

e: lol at 40 gigs of articles for eight users oh god


Return to “Support”

Who is online

Users browsing this forum: No registered users and 12 guests