[389-users] Re: 2.x query performance problem

2023-03-30 Thread Claas Vieler
t." <389-users@lists.fedoraproject.org>, "Claas Vieler" Betreff: [389-users] Re: 2.x query performance problem Hi Claas, Rereading that thread I have a doubt regarding cache priming. The search returns ~500 groups. The first lookup of those groups is significantly longer becau

[389-users] Re: 2.x query performance problem

2023-03-16 Thread Claas Vieler
Hello William   I cant see any difference expect duration   best regards Claas   389-Directory/2.3.2 B2023.073.0958 [16/Mar/2023:08:24:51.321404978 +0100] conn=51 fd=66 slot=66 connection from local to /run/slapd-389ds.socket [16/Mar/2023:08:24:51.323985845 +0100] conn=51 AUTOBIND

[389-users] Re: 2.x query performance problem

2023-03-14 Thread Claas Vieler
looks like there is a significant (>30 times slower) regression in RHDS12 vs RHDS11 with that testcase. In RHDS12, the handling of referral adds a 2 times slower but it is possibly fixed with https://github.com/389ds/389-ds-base/issues/5598. best regards thierry On 3/13/23 17:18, Claas Vieler wr

[389-users] Re: 2.x query performance problem

2023-03-13 Thread Claas Vieler
it should not be called. Just for confirmation, you indexed 'uniqueMember' did you indexed in 'eq' ? best regards thierry On 3/10/23 14:47, Claas Vieler wrote: Hello Thierry,   I can confirm index on 'uniqueMember' for both versions. I also tried to recreate and reindex 'uniqueMember', same res

[389-users] Re: 2.x query performance problem

2023-03-13 Thread Claas Vieler
Hello William,   sorry, your mail was stuck in my spam filter, so I doesnt see it here are the logs with and without option manageDSAit (as Thierry mentioned)     without manageDSAit: [13/Mar/2023:16:16:06.583644293 +0100] conn=32 fd=64 slot=64 connection from local to

[389-users] Re: 2.x query performance problem

2023-03-10 Thread Claas Vieler
ou 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 On 3/7/23 14:54, Claas Vieler wrote: Hello,   we have a search performance probl

[389-users] 2.x query performance problem

2023-03-07 Thread Claas Vieler
Hello,   we have a search performance problem when we migrated from 1.4.4.19 to 2.0.17.   Our environment has about 100k entries, about 15k users and about 10k groups. Also big groups with thousand of users, also users with thousand of group membership. So I would call it a small instance