Re: [Fedora-directory-users] Search optimization?

["Vsevolod (Simon) Ilyushchenko" <simonf cshl edu>]

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 redhat com
> https://www.redhat.com/mailman/listinfo/fedora-directory-users

--

Simon (Vsevolod ILyushchenko)   simonf cshl edu
				http://www.simonf.com

"Think like a man of action, act like a man of thought."

		         Henri Bergson