Gesendet: Mittwoch, 08. März 2023 um 01:11 Uhr Von: "William Brown" <william.brown@suse.com> An: "389-users@lists.fedoraproject.org" <389-users@lists.fedoraproject.org> Betreff: [389-users] Re: 2.x query performance problem
>
> Hi Claas,
> I do not recall a specific change 1.4.4 vs 2.0 that could explain this.
> Do you confirm that 'uniqueMember' is indexed in equality on both ? What are the SRCH records in the access logs (notes=A ?).
> On 2.0, it lasts 2sec, you may try to capture few pstacks that would give some tips.
> regards
> thierry
we need to see the exact filter that's being used, as well as the access logs lines of the slow query to really help here.