All,
Has anyone tried creating an index in openldap to speed-up inequality searches ( eg of the form modifyTimestamp>=20111025162408Z ) on the modifytimestamp or createtimestamp attributes ?
If so, what type of index did you create , did openldap perform reads faster than with no index and did the presence of the index slow down writes to openldap appreciably ?
Many Thanks,
Simon Flack.
This e-mail has been scanned for viruses by the Cable&Wireless Worldwide e-mail security system. For more information on a proactive managed e-mail secure service, visit http://www.cw.com/managed-exchange
The information contained in this e-mail is confidential and may also be subject to legal privilege. It is intended only for the recipient(s) named above. If you are not named above as a recipient, you must not read, copy, disclose, forward or otherwise use the information contained in this email. If you have received this e-mail in error, please notify the sender (whose contact details are above) immediately by reply e-mail and delete the message and any attachments without retaining any copies.
Cable & Wireless Worldwide plc Registered in England and Wales. Company Number 07029206 Registered office: Liberty House, 76 Hammersmith Road, London W14 8UD, England
Flack, Simon writes:
Has anyone tried creating an index in openldap to speed-up inequality searches ( eg of the form modifyTimestamp>=20111025162408Z ) on the modifytimestamp or createtimestamp attributes ?
If so, what type of index did you create,
I haven't tried recently, but use an 'eq' index. This also provides an inequality index for certain syntaxes - timestamps, CSNs, and recently integers, I don't remmeber what else.
did openldap perform reads faster than with no index
An index gives faster non-base searches with such an filer, not faster reads as such. What an index does is narrow down the number of entries in the search scope which slapd has to read and test with the filter.
and did the presence of the index slow down writes to openldap appreciably ?
Each index does slow writes down a somewhat, in particular substring indexes. The question has raraly been relevant: We could go wild with indexes and OpenLDAP would still be faster than we need.
openldap-technical@openldap.org
-
Flack, Simon -
Hallvard B Furuseth