Grouper Users - Open Discussion List

[Tom Barton <>]

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.

Tom

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
> members:
>
> 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.
>
> -K