Re: really slow queries

[ian logan <ian@nmsu.edu>]

Did you setup any indices?  Without indexing searches will take a long
time. The admin guide includes a few examples on how to setup indexing
of attributes (its in the config file chapter.)

Ian


Andy De Petter wrote:
> 
> Hello,
> 
> We are evaluating the OpenLDAP software.. We are currently using 2.0.7, with
> Sleepycat 3.1.17 on a Solaris 7.
> 
> After instaling the sofware, we tried some stresstests on the daemon, and
> something very weird happened.. After inserting about 70000 entries in the
> LDAP (very simple ones, only sn-cn-uid attributes), we tried to do some
> simultaneous queries ....
> 
> After starting up a few hundreds of queries at the same time (searching on
> indexed "sn" attribute), the load of the machine rises up to >20 ...
> 
> We started doing some other tests, and it seems that one simple query
> (searchfilter like '(sn=mysn)') takes upto 15 seconds !!!!
> 
> Have we overlooked something, or is this normal behaviour?
> 
> TIA,
> 
> -Andy
> 
> --
> ......................................................................
> :                                                                    :
> :                              Andy De Petter <andy@ops.skynet.be>   :
> :    Skynet   NV/SA                                System Engineer   :
> :                                                                    :
> : Kol. Bourgstraat 124          _,'|            _.-''``-...___..--'; :
> :    1140  Brussels            /, \'.      _..-' ,      ,--...--'''  :
> :                             < \   .`--'''      `     /|            :
> : Tel +32 (0)2 7061311         `-,;'              ;   ; ;            :
> : Fax +32 (0)2 7061312    __...--''     __...--_..'  .;.'            :
> :                        (,__....----'''      (,..--''               :
> : http://www.skynet.be                                               :
> ......................................................................
> 
> The opinions expressed are personal.