Re: slow queries with long strings in filters

[Sylvain Amrani <sylvain.amrani@gendarmerie.org>]

Hi,

Quanah Gibson-Mount wrote :
>> But theses parameters are only available with openldap 2.3 and it
>> doesn't
>> seem to be exactly my problem (I've no differences between 2,3,4 or 5
>> characters query strings)
>
> A lot of work was done between 2.2 and 2.3 to further optimize search
> speed in bdb & hdb.  I would be curious if you encounter the same
> issues with a newer release.
>
> --Quanah
Thanks to all for your good advices.

Upgrading to 2.3.27 solves all of these issues.

Execution time of a bunch of complex filters was about 8s. All is done
now in 0.03 s with the same filter parameters. Amazing.

Regards,
Sylvain.