[PR #21591] [MERGED] perf: Avoid loading full chat JSON blob for pinned/archived/shared list endpoints #65009

New Issue

GiteaMirror · 2026-05-06T10:45:30-05:00

GiteaMirror commented

2026-05-06 10:45:30 -05:00

📋 Pull Request Information

Original PR: https://github.com/open-webui/open-webui/pull/21591
Author: @Classic298
Created: 2/19/2026
Status: ✅ Merged
Merged: 2/19/2026
Merged by: @tjbck

Base: dev ← Head: chat-list-select

📝 Commits (2)

1810b69 Avoid loading full chat JSON blob for pinned/archived/shared list endpoints
59df676 Merge branch 'dev' into chat-list-select

📊 Changes

2 files changed (+47 additions, -26 deletions)

View changed files

📝 backend/open_webui/models/chats.py (+39 -10)
📝 backend/open_webui/routers/chats.py (+8 -16)

📄 Description

These endpoints only return title, id, and timestamps (ChatTitleIdResponse /
SharedChatResponse) but were loading full ChatModel objects including the
entire conversation JSON blob. Use .with_entities() to select only the
needed columns, matching the existing pattern in get_chat_title_id_list_by_user_id.

Contributor License Agreement

By submitting this pull request, I confirm that I have read and fully agree to the Contributor License Agreement (CLA), and I am providing my contributions under its terms.

Note

Deleting the CLA section will lead to immediate closure of your PR and it will not be merged in.

_{🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.}

## 📋 Pull Request Information **Original PR:** https://github.com/open-webui/open-webui/pull/21591 **Author:** [@Classic298](https://github.com/Classic298) **Created:** 2/19/2026 **Status:** ✅ Merged **Merged:** 2/19/2026 **Merged by:** [@tjbck](https://github.com/tjbck) **Base:** `dev` ← **Head:** `chat-list-select` --- ### 📝 Commits (2) - [`1810b69`](https://github.com/open-webui/open-webui/commit/1810b6911a9f173feab29a7ef819cb693634bfcb) Avoid loading full chat JSON blob for pinned/archived/shared list endpoints - [`59df676`](https://github.com/open-webui/open-webui/commit/59df6761bb3219e693b680e7826e3527d3844a99) Merge branch 'dev' into chat-list-select ### 📊 Changes **2 files changed** (+47 additions, -26 deletions) <details> <summary>View changed files</summary> 📝 `backend/open_webui/models/chats.py` (+39 -10) 📝 `backend/open_webui/routers/chats.py` (+8 -16) </details> ### 📄 Description These endpoints only return title, id, and timestamps (ChatTitleIdResponse / SharedChatResponse) but were loading full ChatModel objects including the entire conversation JSON blob. Use .with_entities() to select only the needed columns, matching the existing pattern in get_chat_title_id_list_by_user_id. ### Contributor License Agreement  By submitting this pull request, I confirm that I have read and fully agree to the [Contributor License Agreement (CLA)](https://github.com/open-webui/open-webui/blob/main/CONTRIBUTOR_LICENSE_AGREEMENT), and I am providing my contributions under its terms. > [!NOTE] > Deleting the CLA section will lead to immediate closure of your PR and it will not be merged in. --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>

GiteaMirror added the pull-request label 2026-05-06 10:45:30 -05:00

GiteaMirror closed this issue

2026-05-06 10:45:32 -05:00

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: github-starred/open-webui#65009