jellyfin/Jellyfin.Server.Implementations/Item/PeopleRepository.cs, branch v12.0-rc5Unnamed repository; edit this file 'description' to name the repository.
https://git.b0n.dev/jellyfin/atom?h=v12.0-rc52026-08-07T15:59:17ZBatch people lookups when building item DTOs2026-08-07T15:59:17Zbrandonbrandon@clinger.dev2026-08-07T15:59:17Zurn:sha1:d6da6906a4b3426f05c5bf4ffe8bab4b2bc78ce8
GetBaseItemDtos already batch fetches user data, child counts, played counts
and artists before its per item loop, but AttachPeople still ran one GetPeople
query per item. Rendering a page of items (for example a large playlist) fired
one extra query per row.
Add GetPeopleByItems to IPeopleRepository, which reads every requested item in a
single query over the people mapping table and returns full PersonInfo (role,
type and sort order) grouped by item id. GetBaseItemDtos prefetches this once
when the People field is requested and passes it into AttachPeople, which reads
from the batch instead of querying per item. The single item GetBaseItemDto path
keeps its existing per item behaviour when no batch is supplied.
Adds a DtoService test asserting people resolve from the batch and the per item
GetPeople is never called.
Project the lowered person credit values once when updating people2026-08-05T11:21:57ZShadowghostGhost_of_Stone@web.de2026-08-05T10:22:55Zurn:sha1:61e75599b30cd346eab743529271ab3e002f0474Fix /Persons favourites timing out by removing the correlated favourites join2026-08-03T22:40:53ZShadowghostGhost_of_Stone@web.de2026-08-03T22:40:53Zurn:sha1:d3c7aa6bd21cfcac488fc5438c8fd34865862500Preserve multiple roles per person type instead of deduping credits by name and type2026-08-01T18:35:27ZShadowghostGhost_of_Stone@web.de2026-08-01T18:35:27Zurn:sha1:cbc2c7c32345f670d928f7840e5fd7422241845dRestrict people, genres, studios and artists to names backed by an item the user can access2026-07-28T19:28:56ZShadowghostGhost_of_Stone@web.de2026-07-28T18:41:21Zurn:sha1:9a258c089dcbc68b12fe63479542fc7158ec7a10Make the /Persons de-duplication use an index instead of grouping the table2026-07-28T18:18:02ZShadowghostGhost_of_Stone@web.de2026-07-28T14:34:45Zurn:sha1:5f5c71ab7542d4dab088773b4ec4f75a369b83ccReduce correlated subqueries to improve performance2026-07-23T18:50:06ZShadowghostGhost_of_Stone@web.de2026-07-23T09:52:26Zurn:sha1:9aa79682bab9a18f87b0c13c776a19e3eb357335Fix similarity (#16942)2026-05-31T15:21:15ZTim EiseleGhost_of_Stone@web.de2026-05-31T15:21:15Zurn:sha1:63d1af5fe7ed67d0e2e56c79ef518a7a87da782f
Fix similarityMerge pull request #16856 from Shadowghost/movie-recommendations2026-05-27T18:59:18ZBond-009bond.009@outlook.com2026-05-27T18:59:18Zurn:sha1:2f17516d4bd8700e4a66f609b9c5fac835020407
Fix movie recommendationsRun tree-wide dotnet format2026-05-21T18:48:41Zjakobkuklajakob.kukla@gmail.com2026-04-16T09:38:01Zurn:sha1:37350282cc18a977162dcf14fe9b6068d29d6edf