Re: Re: Re: Could ldap do max-like or count-like operation as SQL?

[mark@mjwilcox.com]

Performance will largely determine upon the numbers of entries in 
your server & the indexes you maintain. 

Indexes are available for all servers.

You can also improve your searching by using the Virtual List View 
control (which provides a more efficient mechanism for searching 
large search results).

mark


On 21 Jun 00, at 12:05, Yuqing Tang wrote:

> >On Wed, Jun 21, 2000 at 10:17:29AM +0800, Yuqing Tang wrote:
> >> >On Tue, Jun 20, 2000 at 07:31:24PM +0800, Yuqing Tang wrote:
> >> >> As our project go on, we store lots of data into ldap, now we should
> >> >> do some statistics on these data, such as who is the oldest or even 
> >> >> who is the oldest 1000 or how many people live in CA. Could ldap do
> >> >> that? 
> >> >
> >> >LDAP search ...
> >> How to search? Should I search all the entries that satisfied some filter,
> >> and iterator through them to find the max or to count them?
> >> 
> >> I am new to this maillist, actually I am writing a client program to do that,
> >> should I fwd my questiong to another maillist?
> >
> >RTFM.
> >
> >ldapsearch '(age=*)' age | perl -e '$/ = "\n\n"; while( <> ) {/^uid=(\w+).*$/m; $u = $1; /^age=(.*)$/m; $p = $1; print "$p $u\n";}' | sort -n | head -1000 > top-1000-ages.txt
> So if I had 1000000 entries in ldap, I must fisrt get all of them to the client, 
> then iterate through them to do some statistics? Will the performance be very very
> low?
> 
> In another word, do I use ldap in a wrong way?
> >
> >-d
> >
> >-- 
> >come.to/dannyman
> >
> >.
> 
> 
>