offsite.guru/textze
1
0
Fork 0
Code Issues 5 Pull requests Projects Releases Packages Wiki Activity Actions

Add missing database indexes #5

New issue
Open
opened 2026-02-15 17:35:07 -05:00 by benjamin.long · 0 comments
benjamin.long commented 2026-02-15 17:35:07 -05:00
Owner
Copy link

Several frequently queried foreign key columns lack indexes, causing full table scans:

  • Message.user_id
  • Message.conversation_id
  • Conversation.user_id
  • GroupMember.group_id

These will become noticeable as data grows.

Labels

server

Several frequently queried foreign key columns lack indexes, causing full table scans: - `Message.user_id` - `Message.conversation_id` - `Conversation.user_id` - `GroupMember.group_id` These will become noticeable as data grows. ## Labels server
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
main
No results found.
Labels
Clear labels   
android

This issue relates to the android client

  
bug

Something is not working

  
duplicate

This issue or pull request already exists

  
enhancement

New feature

  
help wanted

Need some help

  
invalid

Something is wrong

  
question

More information is needed

  
server

This issue relates to textze-server

  
web-client

This issue relates to the web client

  
wontfix

This won't be fixed

No labels
android
bug
duplicate
enhancement
help wanted
invalid
question
server
web-client
wontfix
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
offsite.guru/textze#5
No description provided.