RE: a better search?

[mikema@crt.com]

	I have added the index's to my slapd.conf file as suggested below.
However, my performance has barely increased.  What could I be doing wrong.
Should I play around with the cache settings in the slapd.conf?  It is still
taking around 60secs to complete this search.

Thanks to all who have responded.

- Mike

> -----Original Message-----
> From:	Simon Murcott [SMTP:simonmu@optimation.co.nz]
> Sent:	Monday, November 08, 1999 1:42 PM
> To:	mikema@crt.com
> Cc:	openldap-software@OpenLDAP.org
> Subject:	Re: a better search?
> 
> On Mon, 8 Nov 1999 mikema@crt.com wrote:
> 
>    	I am experiencing some long search times when trying to do a search
>    on one directory that contains about 4500 entries.  This particular
> search
>    returns only 1 attribute, which contains a unix UID, for every DN
> entry.
>    This is needed to find the next available UID.  However, this one
> search is
>    taking up to about 2 mins to complete.  I am using Net::LDAP perl
> module
>    which I understand may not be the best performer but have no other
> choice
>    due to the platforms I work on.  Does OpenLDAP have the ability to have
>    store procedures as RDMS do?  Or is there a convenient way to run a
> script
>    on the server through another process?  Any information would be
> greatly
>    appreciated.
>    
> Are you caching the uid and uidnumber indexes?
> 
> I have not had any speed problems myself with the perl modules. For
> reference a
> query like
> "(|(&(givenname=simon*)(sn=murcott*))(&(givenname=simon*)(sn=murcott*))(ma
> il=simon*murcott*)(mail=murcott*simon*)(cn=*simon*murcott*)(display-name=*
> simon*murcott*))"
> across a database of 2000 entries on a SPARCstation 5 takes 2 seconds
> (with
> other users on it doing stuff). This query would not complete within the
> 60sec
> timeout until I got the caching correct.
> 
> Regards
> 
> Simon Murcott
> 
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> 
>  Optimation New Zealand Limited (part of the Mentum Group)
>  Level 4, Exchange Place, Willeston Street, Wellington, New Zealand
>  Phone +64 4 4727218, Fax +64 4 4727219, Mobile 025 405821
>  S.Murcott@optimation.co.nz