2009/10/27 Andrey Ivanov <andrey.ivanov(a)polytechnique.fr>:
6 minutes for 25000 entries is obviously too much. On our server (HP
of two
years old ang 2Go of memory) 8300 entries are returned in 0.77 seconds (the
filter is almost like yours - "(&(uid=*)(objectClass=inetOrgPerson))").
There is certainly some problem either with the disk access or with the
memory sizing or with the indexed searches in your configuration... Do you
have the PRESENCE index on uid?
For one moment I thought UID was not indexed, but I checked twice it
is indexed. These are all the attributes indexed in out databases:
aci:
system: true
type: [pres]
entryDN:
system: true
type: [eq]
nscpEntryDN:
system: true
type: [eq]
nsds5ReplConflict:
system: true
type: [eq, pres]
nsUniqueId:
system: true
type: [eq]
numSubordinates:
system: true
type: [pres]
objectClass:
system: true
type: [eq, pres]
parentID:
system: true
type: [eq]
cn:
system: false
type: [pres, eq, sub]
displayName:
system: false
type: [pres, eq, sub]
gidNumber:
system: false
type: [pres, eq]
givenName:
system: false
type: [pres, eq, sub]
mail:
system: false
type: [pres, eq, sub]
mailAlternateAddress:
system: false
type: [pres, eq, sub]
memberOf:
system: false
type: [eq]
memberUid:
system: false
type: [eq]
ntUniqueId:
system: false
type: [eq]
ntUserDomainId:
system: false
type: [eq]
o:
system: false
type: [pres, eq, sub]
ou:
system: false
type: [pres, eq, sub]
sambaDomainName:
system: false
type: [pres, eq]
sambaGroupType:
system: false
type: [pres, eq]
sambaPrimaryGroupSID:
system: false
type: [pres, eq]
sambaSID:
system: false
type: [pres, eq]
sambaSIDList:
system: false
type: [pres, eq]
seeAlso:
system: false
type: [pres, eq, sub]
sn:
system: false
type: [pres, eq, sub]
telephoneNumber:
system: false
type: [pres, eq, sub]
uid:
system: false
type: [pres, eq, sub]
uidNumber:
system: false
type: [pres, eq]
uniqueMember:
system: false
type: [pres, eq, sub]
(This is part of a file we use to define database indexes, adding or
removing necessary attributes to the default indexes).
Regards.