[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