Skip to Content.
Sympa Menu

grouper-users - Re: [grouper-users] Ldappc performance

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] Ldappc performance

Chronological Thread 
  • From: Tom Barton <>
  • To: Kathryn Huxtable <>
  • Cc: Grouper Users <>, Dave Donnelly <>
  • Subject: Re: [grouper-users] Ldappc performance
  • Date: Mon, 12 Feb 2007 16:19:31 -0600

Thanks Kathryn. I'm also CCing Dave Donnelly (signet developer), who is collecting issues with the Subject API and reference implementation that might be addressed in a future 1.0 release.


Kathryn Huxtable wrote:
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