[Date Prev][Date Next]
[Chronological]
[Thread]
[Top]
Building Indices
Okay thanks to some very useful tidbits, (thankyou).
I think I have finally found the cause of my terrible ldap performance.
I am 99.9999% sure it is my indices, or to be more percise the lack
there of.
Querying for 311 uids takes about 5secs. Which are indexed.
Querying for 233 DNS (bind) 5 min. Which are not indexed.
Querying for 286 MTA (sendmail schema) 8min. Which are not indexed.
Now for the question. I know how to create an index, however, anyone
have an idea of which attributes should be indexed for the sendmail
schema and for the DNSZone schema?
this version 2.0.27 on a 2.4.xx Linux. Dual Pentium 2.4ghz w/4gig ram.
ldbm backend....
currently the indices are as follows.
#######################################################################
# ldbm database definitions
#######################################################################
database ldbm
cachesize 10000
dbcachesize 1000000
directory /var/lib/ldap
# Indices to maintain
index objectClass,uid,uidNumber,gidNumber,memberUid eq
index cn,mail,surname,givenname eq,subinitial
thanks in advance :-)
--
robert