[Date Prev][Date Next]
[Chronological]
[Thread]
[Top]
RE: Performance with indexes
Good day,
Thanks for your reply.
You're right.. that index never existed! (I didn't create this schema BTW,
it's someone else's whom I imported). I've added it and it works fantastic
now.
I would have never thought to check that- then again, I would never have
deleted it in the first place =) . Can I ask why the missing objectclass
index causes this to happen?
============================
Darren Gamble
Planner, Regional Services
Shaw Cablesystems GP
630 - 3rd Avenue SW
Calgary, Alberta, Canada
T2P 4L4
(403) 781-4948
> -----Original Message-----
> From: Kurt D. Zeilenga [mailto:Kurt@OpenLDAP.org]
> Sent: Wednesday, June 05, 2002 1:52 PM
> To: Darren Gamble
> Cc: openldap-software@OpenLDAP.org
> Subject: Re: Performance with indexes
>
>
> Sounds like you deleted 'index objectClass eq' from slapd.conf(5).
>
> At 10:09 AM 2002-06-05, 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
>