question about limits

[JJ van Gorkum <job@knowzone.org>]

Hi,

I have a question about limits:

when I do a query like :

ldapsearch -x -b"o=mail,dc=example,dc=com" -w password 
-D"userlogin=user,o=admins,dc=example,dc=com" -LLL 
"(&(mail=*@example.com)(objectClass=mailUser))"

where o=mail,dc=example,dc=com (objectClass=mailUser) contains about 
50000 entries (indexed) the query takes about 35 seconds to complete.

but when I do it like this:

ldapsearch -x -b"o=mail,dc=example,dc=com" -w password 
-D"cn=admin,dc=example,dc=com" -LLL 
"(&(mail=*@example.com)(objectClass=mailUser))"

where : cn=admin,dc=example,dc=com is the root database admin the query 
takes about 0.4 seconds

and  when I do this:

ldapsearch -x -b"o=mail,dc=example,dc=com" -w password 
-D"userlogin=user,o=admins,dc=example,dc=com" -LLL 
"(&(mail=*@example.com*)(objectClass=mailUser))"

the query takes about 0.05 seconds.

I have tried:
- sizelimt size.unckecked=-1
- sizelimit size.hard=-1

but query 1 still takes about 30 seconds (with a cpu load of 99%)

and query 3 is totally strange....

tested with openldap 2.1.30 and 2.2.17

What am I doing wrong here?

--
JJ van Gorkum                             Knowledge Zone
If UNIX isn't the solution, you've got the wrong problem