[midPoint-git] [Evolveum/midpoint] 2b0d37: Remove "distinct" from simple provisioning queries

[mederly]

  Branch: refs/heads/support-4.8
  Home:   https://github.com/Evolveum/midpoint
  Commit: 2b0d376f1905a4d5b5c1192ea2f5cbbaee1f4b3f
      https://github.com/Evolveum/midpoint/commit/2b0d376f1905a4d5b5c1192ea2f5cbbaee1f4b3f
  Author: Pavol Mederly <mederly at evolveum.com>
  Date:   2025-03-27 (Thu, 27 Mar 2025)

  Changed paths:
    M infra/schema/src/main/java/com/evolveum/midpoint/schema/util/ObjectSet.java
    M provisioning/provisioning-impl/src/main/java/com/evolveum/midpoint/provisioning/impl/shadows/manager/ShadowFinder.java

  Log Message:
  -----------
  Remove "distinct" from simple provisioning queries

Queries that look for shadows by their identifier(s) are quite frequent.
It seems that the DISTINCT option makes them extremely slow on the
generic repository, especially when Oracle is involved.

Moreover, the DISTINCT option disables caching of shadows queries,
harming the performance further (see MID-10600).

This commit eliminates that option from these queries.

Related to MID-9594 and MID-10600.

(cherry picked from commit a865b9dccaf12634d8b741ec3a1ece16dc130abd)
(charry picked from commit bee30e6cbad529613cf2b501ce4e56cd48e1df2d)



To unsubscribe from these emails, change your notification settings at https://github.com/Evolveum/midpoint/settings/notifications