[PR #21590] [MERGED] perf: Query title column directly in get_chat_title_by_id instead of loading full chat #49200

New Issue

GiteaMirror · 2026-04-30T01:31:31-05:00

GiteaMirror commented

2026-04-30 01:31:31 -05:00

📋 Pull Request Information

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

Base: dev ← Head: perf-chat-title-query

📝 Commits (1)

d69fb74 Query title column directly in get_chat_title_by_id instead of loading full chat (#157)

📊 Changes

1 file changed (+5 additions, -5 deletions)

View changed files

📝 backend/open_webui/models/chats.py (+5 -5)

📄 Description

Previously loaded the entire ChatModel (including the full conversation JSON blob) just to extract the title string. Now queries only the Chat.title column directly, which is already a top-level DB column.

get_chat_title_by_id: 2 call sites, both in middleware.py (lines 2927 and 4432). It's called to grab the title for notification/logging purposes after a response completes. Low frequency, but saves transmitting the full blob over the wire for something that's just a column read.

Makes the database query MUCH faster as only the title has to be grabbed and also saves network latency and network bandwidth!

For a chat with hundreds of messages, the difference between SELECT title FROM chat WHERE id = ? and SELECT * FROM chat WHERE id = ? is significant at every layer: disk I/O, DB CPU, network, and application memory.

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/21590 **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:** `perf-chat-title-query` --- ### 📝 Commits (1) - [`d69fb74`](https://github.com/open-webui/open-webui/commit/d69fb7448234aea7c6408b1b7f3b314220ab3cef) Query title column directly in get_chat_title_by_id instead of loading full chat (#157) ### 📊 Changes **1 file changed** (+5 additions, -5 deletions) <details> <summary>View changed files</summary> 📝 `backend/open_webui/models/chats.py` (+5 -5) </details> ### 📄 Description Previously loaded the entire ChatModel (including the full conversation JSON blob) just to extract the title string. Now queries only the Chat.title column directly, which is already a top-level DB column. get_chat_title_by_id: 2 call sites, both in middleware.py (lines 2927 and 4432). It's called to grab the title for notification/logging purposes after a response completes. Low frequency, but saves transmitting the full blob over the wire for something that's just a column read. **Makes the database query MUCH faster as only the title has to be grabbed and also saves network latency and network bandwidth!** For a chat with hundreds of messages, the difference between `SELECT title FROM chat WHERE id = ?` and` SELECT * FROM chat WHERE id = ?` is significant at every layer: disk I/O, DB CPU, network, and application memory. ### 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-04-30 01:31:31 -05:00

GiteaMirror closed this issue

2026-04-30 01:31:34 -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#49200