https://bugs.gpodder.org/show_bug.cgi?id=1588
Bug #: 1588
Summary: Optimize DB Query for Episode States by Ref-URLs
Classification: Unclassified
Product: gpodder.net
Version: unspecified
Platform: PC
OS/Version: Linux
Status: CONFIRMED
Severity: feature request
Priority: low
Component: Advanced API (Server-side)
AssignedTo: [email protected]
ReportedBy: [email protected]
Currently users/episode_states_by_ref_urls is the most requested CouchDB view
by about one order of magnitude.
This is because the Advanced API's Episode Actions endpoint (in
mygpo.api.advanced.update_episodes) calls EpisodeUserState.for_ref_urls() for
each episode separately.
EpisodeUserState.for_ref_urls() uses a single key (instead of a range of
startkey and endkey), so this could be replace with one query with multiple
keys. In the returned result,
* duplicates (if any) have to be removed
* missing entries have to be created an inserted (including referenced podcasts
and episodes)
--
Configure bugmail: https://bugs.gpodder.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.
_______________________________________________
gPodder-Bugs mailing list
[email protected]
https://lists.berlios.de/mailman/listinfo/gpodder-bugs
