[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
(&(createTimestamp>=200903010000Z)(createTimestamp<=200904010000Z))
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.
Andrew
--
-----------------------------------------------------------------------
| From Andrew Findlay, Skills 1st Ltd |
| Consultant in large-scale systems, networks, and directory services |
| http://www.skills-1st.co.uk/ +44 1628 782565 |
-----------------------------------------------------------------------