starred/audiobookshelf
1
0
Fork 0
mirror of https://github.com/advplyr/audiobookshelf.git synced 2026-05-30 23:40:40 +02:00
Code Issues 1.0k Packages Projects Releases 10 Wiki Activity

[Enhancement]: variation in execution minute of hourly podcast RSS refreshes #1864

New Issue
Closed
opened 2026-04-25 00:00:37 +02:00 by adam · 2 comments
adam commented 2026-04-25 00:00:37 +02:00
Owner
Copy Link
Copy Source

Originally created by @xo9agq46a8k on GitHub (Apr 6, 2024).

Describe the feature/enhancement

OPML imported podcasts appear to default to refreshing at the top of each hour, which in my case (500+ feeds) resulted in ABS web UI becoming super slugish for the first few of minutes of each hour. How about having them default to refreshing based on the createdAt minute? Such that a createAt timestamp in the podcasts table of "2024-04-05 13:43:22.012 +00:00" would receive an autoDownloadSchedule value of "43 * * * *"? Or perhaps just a random minute value to maximally spread out the tasks of feed refreshing and podcast downloading?

To solve the problem in my specific case I executed the following SQL against the database to randomize the minute of each refresh. I had it generate a number between 8 and 58 assuming those were perhaps the minutes of lightest load on the network/servers. Thanks for reading my feature request!
UPDATE podcasts SET autoDownloadSchedule = (8 + (ABS(RANDOM()) % 51)) || ' * * * *';

Originally created by @xo9agq46a8k on GitHub (Apr 6, 2024). ### Describe the feature/enhancement OPML imported podcasts appear to default to refreshing at the top of each hour, which in my case (500+ feeds) resulted in ABS web UI becoming super slugish for the first few of minutes of each hour. How about having them default to refreshing based on the createdAt minute? Such that a createAt timestamp in the podcasts table of "2024-04-05 13:43:22.012 +00:00" would receive an autoDownloadSchedule value of "43 * * * *"? Or perhaps just a random minute value to maximally spread out the tasks of feed refreshing and podcast downloading? To solve the problem in my specific case I executed the following SQL against the database to randomize the minute of each refresh. I had it generate a number between 8 and 58 assuming those were perhaps the minutes of lightest load on the network/servers. Thanks for reading my feature request! `UPDATE podcasts SET autoDownloadSchedule = (8 + (ABS(RANDOM()) % 51)) || ' * * * *';`
adam added the enhancement label 2026-04-25 00:00:37 +02:00
adam closed this issue 2026-04-25 00:00:38 +02:00
adam commented 2026-04-25 00:00:38 +02:00
Author
Owner
Copy Link
Copy Source

@nichwall commented on GitHub (Apr 6, 2024):

Duplicate of https://github.com/advplyr/audiobookshelf/issues/2312

@nichwall commented on GitHub (Apr 6, 2024): Duplicate of https://github.com/advplyr/audiobookshelf/issues/2312
adam commented 2026-04-25 00:00:39 +02:00
Author
Owner
Copy Link
Copy Source

@advplyr commented on GitHub (Apr 6, 2024):

Duplicate of https://github.com/advplyr/audiobookshelf/issues/2312

@advplyr commented on GitHub (Apr 6, 2024): Duplicate of https://github.com/advplyr/audiobookshelf/issues/2312
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
authentication
backlog
bug
chapter editor
config-issue
ebooks
encoding/embedding
enhancement
help wanted
listening sessions & progress
planned
possible plugin
progress sync
pull-request
Mirrored from GitHub Pull Request
 sorting/filtering/searching
unable to reproduce
upload
users & permissions
waiting
No Label enhancement
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
adam (Adam Melkus)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/audiobookshelf#1864
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?