[Fedora-directory-users] Search optimization?
Vsevolod (Simon) Ilyushchenko
simonf at cshl.edu
Mon Apr 10 20:57:00 UTC 2006
Bingo! Down to 2 seconds! I had to add indexes on uidNumber and gidNumber.
Thanks,
Simon
Nathan Kinder wrote on 04/10/2006 04:07 PM:
> Vsevolod (Simon) Ilyushchenko wrote:
>
>> Hi,
>>
>> I've noticed that FDS is significantly slower in answering queries
>> than openldap. If I run 'ls -l /home' on the list of 64 home
>> directories whose owners are all different, I get the list back in 1
>> second if I use openldap. Version 7 of FDS took 16 seconds, and FDS
>> 1.0.2 takes 12 seconds.
>>
>> The docs mention increasing cache sides to improve performance, but my
>> cache is set to 10 M, which seems to be large enough, and the timing
>> does not improve if I run 'ls -l' repeatedly. Is there anything else I
>> can tune?
>
>
> It sounds like the search is against an unindexed attribute. I'd take a
> look at the search in your access log and check if it says "NOTES=U".
> If so, that means that it is an unindexed search. You would need to
> create the proper indexes for the search to improve the performance.
>
> -NGK
>
>>
>> Thanks,
>> Simon
>
>
>
>
> ------------------------------------------------------------------------
>
> --
> Fedora-directory-users mailing list
> Fedora-directory-users at redhat.com
> https://www.redhat.com/mailman/listinfo/fedora-directory-users
--
Simon (Vsevolod ILyushchenko) simonf at cshl.edu
http://www.simonf.com
"Think like a man of action, act like a man of thought."
Henri Bergson
More information about the Fedora-directory-users
mailing list