RE : tunning search with less tha filter

["CHIROSSEL, Olivier" <olivier.chirossel@sfr.com>]

Hi 

i make a bench 
   first conf with the current index  definition  (index statusprefix eq)
   second with index statusprefix pres,eq

better perf with the second conf (x3)

Regards,


Olivier
________________________________________
De : openldap-technical-bounces@OpenLDAP.org [openldap-technical-bounces@OpenLDAP.org] de la part de CHIROSSEL, Olivier [olivier.chirossel@sfr.com]
Date d'envoi : lundi 26 septembre 2011 18:40
À : openldap-technical@openldap.org
Objet : tunning search with less tha filter

Hi

i have to found entry  with this filter in my  ldap :

 (&(statusprefix=free)(datefinjachere<=20110926))

i defined the datefinjachere attribut like this

attributetype ( 1.3.6.1.4.1.11594.1.2.5.1.7
        NAME 'datefinjachere'
        DESC 'datefinjachere'
        EQUALITY numericStringMatch
        SUBSTR numericStringSubstringsMatch
        ORDERING numericStringOrderingMatch
        SYNTAX 1.3.6.1.4.1.1466.115.121.1.36{8}
        SINGLE-VALUE )

and  i declare in my slapd.conf :

index datefinjachere eq
index statusprefix eq


in the base where i search there is 1024 entry which corresponding or not at the filter

a search take 200 millisecondes for the moment, could someone tell me if there is some tunning configuration for  better performances ?


i see when i log with debug

Sep 26 17:53:09 olivier slapd[3402]: => bdb_presence_candidates (datefinjachere)
Sep 26 17:53:09 olivier slapd[3402]: <= bdb_presence_candidates: (datefinjachere) not indexed

perhaps i have to put
index datefinjachere pres,eq in my conf ?

my *.bdb file take 2G on the disk and i declare 500M of cache berkeley in my myconf

bdb4.8 openldap 2.4.23


in advance, thank you for your time

Regards,


Olivier