[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
> >
> >
> >
>