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 : [email protected] [[email protected]] de la part de CHIROSSEL, Olivier [[email protected]] Date d'envoi : lundi 26 septembre 2011 18:40 À : [email protected] 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
