[Date Prev][Date Next]
[Chronological]
[Thread]
[Top]
Re: Running without indexes
One last question, when removing indexes, do I need to run slapindex,
or will the old files simply age out?
On 10/15/05, Hallvard B Furuseth <h.b.furuseth@usit.uio.no> wrote:
> 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
>