[Date Prev][Date Next] [Chronological] [Thread] [Top]

Re: Adding OU with PSQL backend

On Mon, Apr 20, 2009 at 03:43:00PM +0200, Marcel Berteler wrote:

> But, when we try and get statistical data from the tree, we run into the 
> limitations of LDAP: trying to find all user that have registered last 
> month, using a filter with 2 dates, is just too slow. It takes minutes to 
> come back with a result.

> (If any of you have a way of allowing us to interrogate our BDB backend 
> with SQL like queries that are relatively fast, than please let me know.)

I assume you are searching on createTimestamp - something like


Have you indexed this attribute?

LDAP won't do generic relational operations, but it should be able
to answer that sort of query very well.

|                 From Andrew Findlay, Skills 1st Ltd                 |
| Consultant in large-scale systems, networks, and directory services |
|     http://www.skills-1st.co.uk/                +44 1628 782565     |