Issue 2661 - Configurable substring index lengths
Summary: Configurable substring index lengths
Status: VERIFIED FIXED
Alias: None
Product: OpenLDAP
Classification: Unclassified
Component: contrib (show other issues)
Version: unspecified
Hardware: All All
: --- normal
Target Milestone: ---
Assignee: OpenLDAP project
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-07-21 20:02 UTC by gwingerde@home.nl
Modified: 2014-08-01 21:05 UTC (History)
0 users

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description gwingerde@home.nl 2003-07-21 20:02:15 UTC 
Full_Name: Gertjan van Wingerde
Version: 2.1.22
OS: Linux
URL: ftp://ftp.openldap.org/incoming/gwingerde-openldap-2.1.22-config_substr_length.diff
Submission from: (NULL) (212.120.112.51)


The patch indicated below makes the minimum and maximum lengths for substring
indexing
configurable via slapd.conf, as well as the step size taken while creating the
substring indexes.

The use-case for this patch is an application which is performing
wildcard-searches on
telephone-number prefixes. For this particular application the telephone-numbers
were
stored in international format, making the first 4 characters of all telephone
numbers equal.
Hence, in this setup the standard minimum length of 2 and maximum length of 4 of
OpenLDAP
was not sufficient for efficient substring indexing (the LDAP directory contains
hundreds of
thousands of entries).

As longer substring indexes can have a profound impact on write performance it
is chosen
to make the minimum length, the maximum length and the step size for substring
indexes
configurable, to give administrators full control over the behaviour of their
LDAP directories.

The defaults for the newly introduced configuration items are identical to the
current hardcoded
values.

The uploaded patch contains both changes to the software, as updates for the
slapd.conf
manual page.
Comment 1 wai_un 2003-08-07 18:54:38 UTC 
Full_Name: Gertjan van Wingerde
Version: 2.1.22
OS: Linux
URL: 
ftp://ftp.openldap.org/incoming/gwingerde-openldap-2.1.22-config_substr_length.diff
Submission from: (NULL) (212.120.112.51)


The patch indicated below makes the minimum and maximum lengths for 
substring
indexing
configurable via slapd.conf, as well as the step size taken while 
creating the
substring indexes.

The use-case for this patch is an application which is performing
wildcard-searches on
telephone-number prefixes. For this particular application the 
telephone-numbers
were
stored in international format, making the first 4 characters of all 
telephone
numbers equal.
Hence, in this setup the standard minimum length of 2 and maximum length 
of 4 of
OpenLDAP
was not sufficient for efficient substring indexing (the LDAP directory 
contains
hundreds of
thousands of entries).

As longer substring indexes can have a profound impact on write 
performance it
is chosen
to make the minimum length, the maximum length and the step size for 
substring
indexes
configurable, to give administrators full control over the behaviour of 
their
LDAP directories.

The defaults for the newly introduced configuration items are identical 
to the
current hardcoded
values.

The uploaded patch contains both changes to the software, as updates for the
slapd.conf
manual page.
Comment 2 Kurt Zeilenga 2003-08-09 01:34:27 UTC 
moved from Incoming to Contrib
Comment 3 Kurt Zeilenga 2003-08-20 23:39:26 UTC 
changed notes
Comment 4 Kurt Zeilenga 2003-10-12 20:07:49 UTC 
changed notes
Comment 5 Kurt Zeilenga 2004-05-21 02:47:37 UTC 
changed notes
Comment 6 Howard Chu 2004-09-28 00:54:48 UTC 
changed notes
changed state Open to Test
Comment 7 Kurt Zeilenga 2004-10-04 21:19:45 UTC 
changed notes
changed state Test to Closed
Comment 8 Kurt Zeilenga 2004-10-04 21:20:01 UTC 
changed notes
changed state Closed to Test
Comment 9 Kurt Zeilenga 2004-12-01 19:31:02 UTC 
changed notes
changed state Test to Closed
Comment 10 Howard Chu 2009-02-17 06:59:13 UTC 
moved from Contrib to Archive.Contrib
Comment 11 OpenLDAP project 2014-08-01 21:05:14 UTC 
needs discussion
updated version in HEAD