Re: reindexing required?

[Howard Chu <hyc@symas.com>]

Howard Chu wrote:

> Digant Kasundra wrote:
>
> > I've just added a new attribute to my schema and added values for it 
> > in my directory.  Its an attribute that will be used as a filter so 
> > I've added it to the list of things to be indexed.  However, bringing 
> > down the directory and reindexing takes a long long long time.  Is it 
> > necessary to do that or can openldap build up an index table for it on 
> > the fly?

> If you define the index before adding the attribute then it will be 
> built up on the fly. If the attribute already exists in the directory 
> and then you define the index, then you must run slapindex.

By the way, after some more research/benchmarking, we've found a way to 
make slapindex significantly faster on large databases. The code is now 
in OpenLDAP's CVS HEAD. (see the back-bdb "linearindex" config option.)

And another note, if you only need to run slapindex because you've added 
a new index, then you should run it with all the other indices commented 
out. That will also make things much faster, since it won't waste time 
working on existing indices that don't need updating.
--
  -- Howard Chu
  Chief Architect, Symas Corp.       Director, Highland Sun
  http://www.symas.com               http://highlandsun.com/hyc
  Symas: Premier OpenSource Development and Support