Skip to Content.
Sympa Menu

grouper-users - Re: [grouper-users] Slow SQL Loader Job

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] Slow SQL Loader Job

Chronological Thread 
  • From: David Langenberg <>
  • To: "Bryan E. Wooten" <>
  • Cc: "" <>
  • Subject: Re: [grouper-users] Slow SQL Loader Job
  • Date: Thu, 30 Jan 2014 08:38:20 -0700

Hi Bryan,

The first place I'd start is looking at my subject source configuration and the LDAP server and ensure that: the queries that grouper is performing are searching against indexed attributes, the indexes are fully built-out, and they are being used in the search.  If not, tweak each end (subject config & ldap) until those are snappy.  


On Thu, Jan 30, 2014 at 8:24 AM, Bryan E. Wooten <> wrote:

So I have refreshed by LDAP subject source server and my test data base had also been refreshed.


At this point I obliterated my stem containing all the course enrollment loader groups.


I then restarted Grouper. The Grouper loader job (SQL_GROUP_LIST) has now be running for over 18 hours and has still not completed, it is continuing to add course groups but is not anywhere near completion.


How do I go about diagnosing this slowness?





David Langenberg
Identity & Access Management
The University of Chicago

Archive powered by MHonArc 2.6.16.

Top of Page