[Date Prev][Date Next] [Chronological] [Thread] [Top]

RE: Performance with indexes



Good day,

Thanks for your reply.

My message stated that this was done.

============================
Darren Gamble
Planner, Regional Services
Shaw Cablesystems GP
630 - 3rd Avenue SW
Calgary, Alberta, Canada
T2P 4L4
(403) 781-4948


> -----Original Message-----
> From: Christoph Neumann [mailto:enigma@apu.edu]
> Sent: Wednesday, June 05, 2002 11:28 AM
> To: Darren Gamble
> Cc: openldap-software@OpenLDAP.org
> Subject: Re: Performance with indexes
> 
> 
> Don't forget to run "slapindex" when you change your index 
> configuration.
> 
> - Christoph
> 
> 
> On Wed, 5 Jun 2002, Darren Gamble wrote:
> 
> > Good day,
> > 
> > I'm having some performance problems under Red Hat 7.3 
> (openldap 2.0.23).
> > 
> > I've just imported some data from another LDAP database, 
> which contains
> > information about some hosts.  I had done some queries on 
> the "hostName"
> > attribute, which there had been no index on.  Each search 
> took about 30
> > seconds to complete, which wasn't fast enough for what I 
> wanted to do.
> > 
> > So, I stopped the server and added:
> > 
> > index   hostname        eq
> > 
> > to the conf file.  I ran slapindex, chown'ed the new 
> "hostName.gdbm" index
> > file to the ldap user, and then started the server.
> > 
> > After all that, there was absolutely no change in 
> performance, though.  The
> > queries still take 30 seconds to complete.
> > 
> > The ldap server logs the request properly:
> > 
> > conn=0 op=1 SRCH base="<my basedn here>" scope=2
> > filter="(hostName=host.domain.com)"
> > 
> > Is there any reason why this index would not have helped?  
> I would have
> > thought that this type of query would have been exactly the 
> sort that would
> > have been speeded up by an 
> > "eq" index.
> > 
> > Is there anything else that I could check, beyond the logs?
> > 
> > Thanks in advance!
> > 
> > ============================
> > Darren Gamble
> > Planner, Regional Services
> > Shaw Cablesystems GP
> > 630 - 3rd Avenue SW
> > Calgary, Alberta, Canada
> > T2P 4L4
> > (403) 781-4948
> > 
> > 
> > 
>