[Date Prev][Date Next] [Chronological] [Thread] [Top]

Re: Running without indexes



matthew sporleder writes:
> I know this consultant situation well, and am trying to avoid it right
> now.  The problem really is that I have 10+ million entries, so each
> write (this is a writing master.  Almost never any searches) with an
> index = many writes.  I'll drop it down to object class and see how
> performance looks from there.

You might want to set the "unchecked" sizelimit, for a max number of
entries to examine _after_ indexes have been applied.  That way you get
instant adminLimitExceeded (and no entries) instead of a slow
sizeLimitExceeded for an attempt to examine your millions of entries.

If you in addition use loglevel 256 and grep the syslog output for
err=11 (adminLimitExceeded), you'll discover any indexes you need to
add - or maybe clients which should use different searches.

Beware that what is indexed is a hash of the value, not the value itself
(independently of whether the database is using a hash table) - so leave
room for hash collisions.  That applies even to the DN used to look up
an entry.

-- 
Hallvard