Re: performance

[Patrick Timmons <ptimmons@courriel.polymtl.ca>]

You do not have a substring index. I bet the slow queries are for substring
match.

Javier Irato wrote:
> 
> Hello and thanks for the help
> Openldap version 1.2.9-5
> RedHat linux version 6.2
> The data base has less than 1300 entrances, is indexed and formed for
> Netscape Messenger.
> 
> slapd.conf
> include         /etc/openldap/slapd.at.conf
> include         /etc/openldap/slapd.oc.conf
> 
> schemacheck     off
> #referral       ldap://root.openldap.org/
> 
> pidfile         /var/run/slapd.pid
> argsfile        /var/run/slapd.args
> 
> #######################################################################
> # ldbm database definitions
> #######################################################################
> 
> database        ldbm
> #suffix         "cn=manager, mail=manager@blp.com.ar"
> #suffix         "dc=blp, dc=com, dc=ar"
> suffix          "ou=People, o=blp.com.ar"
> #rootdn         "cn=Manager, dc=blp, dc=com, dc=ar"
> #rootdn         "cn=Manager, o=Banco de La Pampa, c=AR"
> #rootpw         secret
> # cleartext passwords, especially for the rootdn, should
> # be avoid.  See slapd.conf(5) for details.
> directory       /usr/tmp
> cachesize 100000
> dbcachesize 1000000
> index default pres,eq
> 
> The problem is that the response time in some cases is smaller to 1
> second and in other cases is of 120 seconds
> 
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Messenger - Talk while you surf!  It's FREE.
> http://im.yahoo.com/

-- 
Patrick Timmons, service informatique