[Pkg-openldap-devel] Bug#436954: Bug#436954: slapd: wishlist item: re-index at startup

[Quanah Gibson-Mount]

--On Tuesday, January 15, 2008 1:28 PM -0600 Pat Riehecky 
<prieheck at iwu.edu> wrote:

> Start up seems reasonable simply because I/O should be very quiet then.
> It will  take forever on large databases, but for replicated databases a
> phased reindex  /could/ come in handy.  I know at my site (a university)
> we do crazy bulk loads once a year (incoming freshman) and performance
> isn't so snappy until after a reindex.  It might be my tunings, but with
> the re-index everything goes fine so my thinking is it is a few
> fragmented indexes....

I'd suspect there's something else going on.  BTW, I worked at Stanford 
University for many years maintaining their directory servers, and while 
proper indices are definitely a must, re-indexing was only necessary when 
changing them.  Otherwise, performance was spectacular.  Properly tuning 
OpenLDAP is always a must. ;)

Note that prior to OpenLDAP 2.4, indices are not truncated when slapindex 
is run.  OpenLDAP 2.4 adds the -t option to truncate the existing indices 
out of the database, which is also handy. ;)

--Quanah




--

Quanah Gibson-Mount
Principal Software Engineer
Zimbra, Inc
--------------------
Zimbra ::  the leader in open source messaging and collaboration