Subject: Grouper Users - Open Discussion List
- 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.
- Ldappc performance, Kathryn Huxtable, 02/12/2007
Archive powered by MHonArc 2.6.16.