rainbownapkin/canopy
1
0
Fork 0
Code Issues 2 Pull requests Actions Packages Projects Releases Wiki Activity

Reduce Schedule-related DB Calls #181

New issue
Closed
opened 2025-09-17 08:01:03 -04:00 by rainbownapkin · 4 comments
rainbownapkin commented 2025-09-17 08:01:03 -04:00 (Migrated from gitlab.com)
Copy link

Certain scehdule functions, especially rescheduling multiple pieces of media, can take longer than they should due to excessive database activity.

In worst case scenarios, such as ending a stream in pusback mode with a days worth of media to re-queue, the server can sometimes even hang, temporarily refusing to respond to web-requests.

Certain scehdule functions, especially rescheduling multiple pieces of media, can take longer than they should due to excessive database activity. In worst case scenarios, such as ending a stream in pusback mode with a days worth of media to re-queue, the server can sometimes even hang, temporarily refusing to respond to web-requests.
rainbownapkin commented 2025-09-17 08:01:03 -04:00 (Migrated from gitlab.com)
Copy link

added #164 as parent issue

added #164 as parent issue
rainbownapkin commented 2025-09-17 08:09:23 -04:00 (Migrated from gitlab.com)
Copy link

changed the description

changed the description
rainbownapkin added a new dependency 2025-09-25 05:39:30 -04:00
#164 Tweaks and Fixes
rainbownapkin commented 2025-11-01 11:36:35 -04:00
Owner
Copy link

Optimized queue.removeRange(): dd36b1d923

Currently rolling on a verbose queue again to track saves. DB schedule processing now happens pretty fast, just need to send the queue out after large crunches instead of during to make it look quicker on the client end.

Optimized queue.removeRange(): dd36b1d923 Currently rolling on a verbose queue again to track saves. DB schedule processing now happens pretty fast, just need to send the queue out after large crunches instead of during to make it look quicker on the client end.
rainbownapkin commented 2025-11-03 00:14:56 -05:00
Owner
Copy link

Finished optimizing automated queue transactions: 75301ec7d9

Remove-range and pushback livestream end methods now run near-instantaneously on reasonably sized schedules.

Finished optimizing automated queue transactions: 75301ec7d9 Remove-range and pushback livestream end methods now run near-instantaneously on reasonably sized schedules.
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
main
dev
0.4-indev-hotfix-3
0.4-indev-hotfix-2
0.4-indev-hotfix-1
0.4-indev
0.3-indev-hotfix-1
0.3-indev
verbose-queue
0.2-indev
0.1-indev
No results found.
Labels
Clear labels   
Bug

   
Cleanup/Refactor

   
Core Feature

   
Documentation

   
Feature

   
Performance Improvement

   
Security Improvement

   
UX/Accessibility

   
Unreproducable Bug
No labels
Bug
Cleanup/Refactor
Core Feature
Documentation
Feature
Performance Improvement
Security Improvement
UX/Accessibility
Unreproducable Bug
Milestone
Clear milestone
No items
No milestone
Canopy v0.4-Indev
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
2 participants
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Blocks
#164 Tweaks and Fixes
rainbownapkin/canopy
Reference: rainbownapkin/canopy#181
No description provided.
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?