[389-users] Query blocking server

[Juan Asensio Sánchez]

2009/10/27 Andrey Ivanov <andrey.ivanov at 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.