Skip to Content.
Sympa Menu

grouper-users - Ldappc performance

Subject: Grouper Users - Open Discussion List

List archive

Ldappc performance

Chronological Thread 
  • From: Kathryn Huxtable <>
  • To: Grouper Users <>
  • Subject: Ldappc performance
  • Date: Mon, 12 Feb 2007 11:08:40 -0600

It looks like a lot of the culprit is the subject API. We use a JDBC
connector. The JDBCSourceAdapter class in subject 0.2.1 does not use
prepared statement handles. I get the following for a group with 13,357

Lookup time: 142327
Finder time: 50181

Using prepared statements I get:

Lookup time: 26550
Finder time: 53345

The times are in milliseconds. The lookup time is the total time required
for the member.getSubject() calls to complete and the finder time is the
total time for all the Provisioner.findSubjectDn(...) calls to complete.

These calls are in GroupEntrySynchronizer.storeGroupData.

Obviously, I can speed up the Provisioner.findSubjectDn call by cheating and
using knowledge of how DNs are constructed from our IdMS, but you probably
ought to think about using prepared statements.

Prepared statements also eliminate problems with SQL injection.


Archive powered by MHonArc 2.6.16.

Top of Page