| Age | Commit message (Collapse) | Author |
|---|
|
Avoid full people scans and writes for unchanged credits
Original-merge: 63c81a9975c339a0757142cb69a318b50b85d216
Merged-by: crobibero <cody@robibe.ro>
Backported-by: Cody Robibero <cody@robibe.ro>
|
|
Check Live TV access for a single user instead of enumerating all users
Original-merge: 2bcd3b1efb121ad661495570b43aace247ee0a27
Merged-by: crobibero <cody@robibe.ro>
Backported-by: Cody Robibero <cody@robibe.ro>
|
|
Drop dead item data and fix query ordering and bound parameters
Original-merge: 3daa917de024dbb605e0686f632c17729dc9527c
Merged-by: crobibero <cody@robibe.ro>
Backported-by: Cody Robibero <cody@robibe.ro>
|
|
Populate missing tags array in Filters2
Original-merge: 3d52fbe84e78d6447465bb831039dabb6142ca67
Merged-by: crobibero <cody@robibe.ro>
Backported-by: Cody Robibero <cody@robibe.ro>
|
|
Clean up orphaned people when deleting items
Original-merge: f6cbafc36e66ca676a87f22b0faeaaf571d9af3f
Merged-by: crobibero <cody@robibe.ro>
Backported-by: Cody Robibero <cody@robibe.ro>
|
|
Release a folder's children once its subtree has been scanned
Original-merge: 2f2adae7d99537e53417f6d92aa3d40345a17b99
Merged-by: crobibero <cody@robibe.ro>
Backported-by: Cody Robibero <cody@robibe.ro>
|
|
Fix /UserViews exhausting memory and reporting random child counts
Original-merge: a838a06aa51eac388a76e9e6421f1a80873c417b
Merged-by: crobibero <cody@robibe.ro>
Backported-by: Cody Robibero <cody@robibe.ro>
|
|
Delete the full ownership closure when deleting items
Original-merge: 705b69e93d7ea86346348b5ad2a97e0f54494f04
Merged-by: crobibero <cody@robibe.ro>
Backported-by: Cody Robibero <cody@robibe.ro>
|
|
Fix versions of a video still listing separately from their group and preserve manual merges
Original-merge: cabec7ec28df671e3bb1c360c32db60b085f4084
Merged-by: crobibero <cody@robibe.ro>
Backported-by: Cody Robibero <cody@robibe.ro>
|
|
Expose optimized ItemCounts for byName items
|
|
|
|
|
|
|
|
Bound change batches during a scan; keep ffprobe and image saves from failing
|
|
|
|
|
|
The legacy filter queries projected ItemValue before grouping tags and genres. EF Core translated that shape into duplicated correlated aggregates, causing multi-minute requests for libraries with many distinct values and blocking unrelated SQLite-backed API calls.
Join ItemValuesMap directly to ItemValues before grouping. This preserves type and item filtering, clean-value grouping, minimum-value selection and ordering while producing one aggregate query. Add an in-memory SQLite regression test for result semantics and both SQL shapes.
|
|
Fix recursive handling for LinkedChildren
|
|
Fix item counts on the by-name endpoints
|
|
|
|
|
|
|
|
Delete credits nothing maps to and bound item-by-name folder names
|
|
|
|
Ordering mapped both keys to the item's own stored UserData row. Folders do not
have one: a series, season or box set counts as played when no descendant is
left unplayed, which is what the isPlayed filter and the DTO both report. A
mixed library therefore sorted every series and box set into the unplayed group,
and a query could filter and sort by two different notions of "played".
Extract the filter's predicate into BuildIsPlayedFilter and route both sort keys
through it so the two cannot drift apart again.
|
|
|
|
Look up people by item via the credit map instead of a full scan
|
|
Optimize query helper memory
|
|
|
|
Co-Authored-By: Cody Robibero <cody@robibe.ro>
|
|
# Conflicts:
# src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/JellyfinDbModelSnapshot.cs
|
|
|
|
|
|
|
|
Fix SQLite variable limit in child count batches
|
|
|
|
|
|
|
|
|
|
|
|
Bugfix: #17547 | Batching MediaSourceCount into one call
|
|
Fix PersonTypes not applied when filtering by person
|
|
fix: correct IsAiring negation to exclude airing items
|
|
Cleanup and simplify query helpers
|
|
|
|
|
|
Filter the parent ids with the WhereOneOrMany query helper instead of a
raw Contains so the id list is wrapped in EF.Parameter and EF Core reuses
one compiled query plan across calls, matching how the rest of the item
queries build their id filters.
|
|
Rename GetItemsWithAlternateVersions to GetItemIdsWithAlternateVersions
across the interfaces and implementations since it returns ids. Return
the hashset straight from the query instead of materializing an array
first. Rename the DtoService guard to mayHaveAlternateVersions and
invert it so the computed path is the explicit case. Assert the media
source count value in the batch skip test and add a test covering an
item that is in the returned set still resolving to the correct count.
|
|
Browsing a page of videos with the MediaSourceCount field ran one alternate
version query per item, each opening a fresh DbContext. On a large library that
turned a single page into hundreds of sequential round trips and made the Items
endpoint take tens of seconds while holding a request thread the whole time.
Detect which videos own alternate versions once per page with a single query,
mirroring the existing people batch. Videos absent from that set have a single
media source, so the per item lookups are skipped for the common case. Behavior
is unchanged: a video with no alternates already resolved to a count of one.
Adds a regression test asserting the count resolves from the batch and the per
item lookups are never called.
|
|
Batch people lookups when building item DTOs
|
