Speeding up LDAP delta aggregations?

[hooverd (David Hoover)]

Which IIQ version are you inquiring about?

8.4p1

Share all details about your problem, including any error messages you may have received.

This is not an Active Directory application. This is 389ds.

We’re running a delta aggregation for an LDAP aggregation and it is significantly slower than our partitioned full aggregations. We have 52 partitions, partitioned by username, for the full and roughly half a million entries. On the LDAP side, we’ve set up an equality index on the modifyTimestamp attribute and that seems to help somewhat: it brought our delta down from 3 hours to 1 hour. For comparison, the full runs in about 15 minutes assuming minimal changes. So, for people who have used delta aggregations for non-AD LDAP, have you found any solutions to this issue?

[enistri_devo (Emanuele Nistri)]

Hi @hooverd,

how do you hahve configured the thread on server configuration and requestDefinition configuration?

[sunny_tsang]

Do your delta aggregations get slower over time after a reboot or is it always running that slow? Just wondering if you configured connection pool timeouts.

[hooverd (David Hoover)]

We’ve optimized our server threads and LDAP connection pool settings. It turns out the issue was that we hadn’t actually applied the index to the modifyTimestamp attribute… D’oh.