Re: Serious performance problems

[Mikel.Santos@idom.com]

Hi Hallvard,

The fields I want to perform searches on are all indexed and I have run
slapindex after adding "index" directives in slapd.conf. Still no way...

Thank you



                                                                           
             Hallvard B                                                    
             Furuseth                                                      
             <h.b.furuseth@usi                                        Para 
             t.uio.no>                 Mikel.Santos@idom.com               
             Enviado por:                                               cc 
             Hallvard Breien           openldap-technical@openldap.org     
             Furuseth                                               Asunto 
             <h.b.furuseth@usi         Re: Serious performance problems    
             t.uio.no>                                                     
                                                                           
                                                                           
             25/04/2008 15:15                                              
                                                                           
                                                                           




You need to add indexes for whatever you filter for.  Without them,
every search must examine all entries in scope for the search.
Include 'index objectClass eq' no matter what else, since slapd
often adds an objectClass component to your filter internally.

You can use loglevel 256 to see what your clients search for.

Also messges like
   <= bdb_<inequality, substring, etc>_candidates: (foo) not indexed
if I remember correctly.

If the clients search for (&(foo=...)(bar=...)) you might only need an
index for one of foo and bar, since each 'and' component narrows down
the search.  If they search for (|(foo=...)(bar=...)) you need both.
Even if you don't have both attributes in the database, because slapd
doesn't know that.  Except you don't need (and can't) index attributes
your included schema doesn't define.

If you add indexes by editing slapd.conf rather than via cn=config, stop
slapd and run sbin/slapindex to actually build the indexes.  Without
slapindex, slapd will think the empty index means nothing in the
database matches the indexed attribute.

--
Hallvard