Silvan 8ac4b61ee6 perf(query): reduce user query duration (#10037) ...

# Which Problems Are Solved

The resource usage to query user(s) on the database was high and
therefore could have performance impact.

# How the Problems Are Solved

Database queries involving the users and loginnames table were improved
and an index was added for user by email query.

# Additional Changes

- spellchecks
- updated apis on load tests

# additional info

needs cherry pick to v3

(cherry picked from commit 4df138286b)

2025-06-12 07:06:45 +02:00

..

01_update_login_names3_view.sql

perf(query): reduce user query duration (#10037)

2025-06-12 07:06:45 +02:00

02_create_index.sql

perf(query): reduce user query duration (#10037)

2025-06-12 07:06:45 +02:00