Livio Spring fefeaea56a
perf: improve org and org domain creation (#10232)
# Which Problems Are Solved

When an organization domain is verified, e.g. also when creating a new
organization (incl. generated domain), existing usernames are checked if
the domain has been claimed.
The query was not optimized for instances with many users and
organizations.

# How the Problems Are Solved

- Replace the query, which was searching over the users projection with
(computed loginnames) with a dedicated query checking the loginnames
projection directly.
-  All occurrences have been updated to use the new query.

# Additional Changes

None

# Additional Context

- reported through support
- requires backport to v3.x
2025-07-10 15:17:49 +00:00
..
2022-04-26 23:01:45 +00:00
2020-03-27 13:57:16 +01:00
2023-04-26 19:55:13 +03:00
2022-04-26 23:01:45 +00:00
2023-05-07 16:47:43 +02:00