[PR #7839] fix(server): face search results not always sorted #11800

Closed
opened 2026-02-05 14:46:09 +03:00 by OVERLORD · 0 comments
Owner

Original Pull Request: https://github.com/immich-app/immich/pull/7839

State: closed
Merged: Yes


Description

VBASE doesn't have a guarantee of sort order, so it's possible for the most similar face to not be the top result. This is bounded by the fact that we have a distance threshold, but it's still better to sort here to make sure we pick the most similar face every time. The overhead of this is almost nothing since the number of rows is so low.

**Original Pull Request:** https://github.com/immich-app/immich/pull/7839 **State:** closed **Merged:** Yes --- ## Description VBASE doesn't have a guarantee of sort order, so it's possible for the most similar face to not be the top result. This is bounded by the fact that we have a distance threshold, but it's still better to sort here to make sure we pick the most similar face every time. The overhead of this is almost nothing since the number of rows is so low.
OVERLORD added the pull-request label 2026-02-05 14:46:09 +03:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: immich-app/immich#11800