[Date Prev][Date Next]
RE: Performance with indexes
Thanks for your reply.
My message stated that this was done.
Planner, Regional Services
Shaw Cablesystems GP
630 - 3rd Avenue SW
Calgary, Alberta, Canada
> -----Original Message-----
> From: Christoph Neumann [mailto:firstname.lastname@example.org]
> 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
> - 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