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