Search optimization?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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




[Index of Archives]     [Fedora User Discussion]     [Older Fedora Users]     [Fedora Announce]     [Fedora Package Announce]     [EPEL Announce]     [Fedora News]     [Fedora Cloud]     [Fedora Advisory Board]     [Fedora Education]     [Fedora Security]     [Fedora Scitech]     [Fedora Robotics]     [Fedora Maintainers]     [Fedora Infrastructure]     [Fedora Websites]     [Anaconda Devel]     [Fedora Devel Java]     [Fedora Legacy]     [Fedora Desktop]     [Fedora Fonts]     [ATA RAID]     [Fedora Marketing]     [Fedora Management Tools]     [Fedora Mentors]     [Fedora Package Review]     [Fedora R Devel]     [Fedora PHP Devel]     [Kickstart]     [Fedora Music]     [Fedora Packaging]     [Centos]     [Fedora SELinux]     [Fedora Legal]     [Fedora Kernel]     [Fedora QA]     [Fedora Triage]     [Fedora OCaml]     [Coolkey]     [Virtualization Tools]     [ET Management Tools]     [Yum Users]     [Tux]     [Yosemite News]     [Yosemite Photos]     [Linux Apps]     [Maemo Users]     [Gnome Users]     [KDE Users]     [Fedora Tools]     [Fedora Art]     [Fedora Docs]     [Maemo Users]     [Asterisk PBX]     [Fedora Sparc]     [Fedora Universal Network Connector]     [Fedora ARM]

  Powered by Linux