Re: Slow search with cn=*, not with cn=abc*

[Tony Earnshaw <tonye@billy.demon.nl>]

søn, 11.04.2004 kl. 19.33 skrev Ace Suares:

> I am encountering a slow search when I search for something like
> 	(&(objectclass=qmailuser)(cn=*))
> but not if I use something like
> 	(&(objectclass=qmailuser)(cn=abc*))
> 
> I use openLDAP 2.1.26, bdb 4.2.52 with the latest patches, on Debian Woody.

I dropped back to OL from 2.2.8 to 2.1.29 in the weekend and just tried
this for you (but with max 100 entries):

ldapsearch -x '(&(objectclass=CourierMailAccount)(cn=t*))' cn, etc (as
you stated). All were more or less instantaneous (didn't take the time).
Indices: cn pres,eq objectClass pres,eq.

This was using ldapi, BDB 4.2.52/patches, RedHat RHEL3

--Tonni

-- 
Kattekots op de vloer
na de moeë thuiskomst
weinig walg
getrouw als kind
de kat heet welkom.

mail: billy - at - billy.demon.nl
http://www.billy.demon.nl