Andrey Antukh 8952d70fd2

⚡ Optimize get-profiles-for-file-comments query (#11622) ...

Rewrite sql:file-comment-users to join comment with
comment_thread and union the requesting profile id, then
join the resulting small id set against profile.

The previous "id IN (subquery) OR id = ?" forced a
sequential scan over the whole profile table with a hashed
subplan filter, taking ~1.9s on large instances. The
semi-join lets the planner use profile_pkey, dropping the
query to sub-millisecond time. UNION (not UNION ALL) keeps
the previous dedup semantics when the requesting profile is
also a commenter.

AI-assisted-by: deepseek-flash

2026-09-10 16:45:22 +02:00

..

dev

♻️ Refactor internal organization of system initialization

2026-07-22 14:18:51 +02:00

resources

🐛 Fix default team and UI labels to use Personal Projects (#11418)

2026-08-28 14:04:56 +02:00

scripts

✨ Add media-processor service for image and font processing (#10767)

2026-08-05 09:41:48 +02:00

src

⚡ Optimize get-profiles-for-file-comments query (#11622)

2026-09-10 16:45:22 +02:00

test

🐛 Add ssrf check for nitrate sso and add timeouts to http client (#11576)

2026-09-09 11:23:53 +02:00

build.clj

🐛 Fix unexpected exception on logger caused by log4j2 plugin

2023-02-11 00:52:23 +01:00

deps.edn

⬆️ Update JVM, pnpm and node dependencies (#11404)

2026-09-01 12:01:35 +02:00

package.json

⬆️ Update pnpm to 12.3.4 across all workspaces

2026-09-09 08:04:11 +02:00

pnpm-lock.yaml

⬆️ Update pnpm to 12.3.4 across all workspaces

2026-09-09 08:04:11 +02:00

pnpm-workspace.yaml

🔧 Pin all pnpm workspaces to one shared pnpm store

2026-09-09 08:04:11 +02:00

tests.edn

🔧 Change backend test runner to kaocha

2024-05-29 19:05:04 +02:00