[PR #19657] feat: add index for workflow_conversation_variables.conversation_id #29204

Closed
opened 2026-02-21 20:45:04 -05:00 by yindo · 0 comments
Owner

Original Pull Request: https://github.com/langgenius/dify/pull/19657

State: closed
Merged: Yes


Summary

close #19656

This commit adds an index to the conversation_id column in the workflow_conversation_variables table to improve query performance when filtering by conversation ID. This is particularly important for API endpoints that retrieve conversation variables for a specific conversation.

The index is created via a new migration file and will help optimize database queries as the application scales with more conversations and variables.

Screenshots

Before After
... ...

Checklist

Important

Please review the checklist below before submitting your pull request.

  • This change requires a documentation update, included: Dify Document
  • I understand that this PR may be closed in case there was no previous discussion or issues. (This doesn't apply to typos!)
  • I've added a test for each change that was introduced, and I tried as much as possible to make a single atomic change.
  • I've updated the documentation accordingly.
  • I ran dev/reformat(backend) and cd web && npx lint-staged(frontend) to appease the lint gods
**Original Pull Request:** https://github.com/langgenius/dify/pull/19657 **State:** closed **Merged:** Yes --- # Summary close #19656 This commit adds an index to the conversation_id column in the workflow_conversation_variables table to improve query performance when filtering by conversation ID. This is particularly important for API endpoints that retrieve conversation variables for a specific conversation. The index is created via a new migration file and will help optimize database queries as the application scales with more conversations and variables. # Screenshots | Before | After | |--------|-------| | ... | ... | # Checklist > [!IMPORTANT] > Please review the checklist below before submitting your pull request. - [ ] This change requires a documentation update, included: [Dify Document](https://github.com/langgenius/dify-docs) - [x] I understand that this PR may be closed in case there was no previous discussion or issues. (This doesn't apply to typos!) - [x] I've added a test for each change that was introduced, and I tried as much as possible to make a single atomic change. - [x] I've updated the documentation accordingly. - [x] I ran `dev/reformat`(backend) and `cd web && npx lint-staged`(frontend) to appease the lint gods
yindo added the pull-request label 2026-02-21 20:45:04 -05:00
yindo closed this issue 2026-02-21 20:45:04 -05:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: langgenius/dify#29204