On 05/10/2012 09:46 PM, rrawson wrote:
> I have an implementation getting ready to go live, the design has some
> Level 30 roles which are the parents of some L 10 roles so when I assign
> a user to the L 30 role they might get 4-5 L 10 roles which gives them
> 10 or so resources. Works great one off. Works very well for a larger
> scale, except it's pretty slow. Assign 50,000 of these and the RR driver
> is quite backed up trying to process 1/2 million direct and inherited
> role assignments.
> Any suggestions on optimization? Indexes that might help?
> Inquiring minds want to know.
> thnx
> Rob

Greetings Rob,
What version of the User App are using at this engagement?

Steven Williams
Lead Software Engineer