We have a CRM implementation with an unusually large number of
Resource Groups (more than 10,000) as they are used for both skills
and geographical breakup. The problem is that CRM's handliong of this
is less than ideal in the System User dialog and whenever a user
selected the "Resource Groups" related view or "Serivces" related view
we get timeouts followed by an Out of Memory exception which kills the
w3wp process.

I have discovered from the logging that the system queries each group
in the system in turn to see if the user is a member or not, one at a
time. Not a very efficient way to query a database and obviously the
root of the problem. Acknowledging this, is there a way I can
increase the memory headroom or the timeout length to allow the
laborious process to complete?

IIS is already configured with no maximums on the worker processes and
the machine has plenty of physical and pagefile memory available when
the process dies.

Anyone have any ideas?

Regards,
Richard.

On Mar 3, 4:14*pm, "Richard Hauer (5 Limes)" <richard.ha...@gmail.com>
wrote:
Further to my post, httpRuntime execution timeout is set to 600, SQL
query timeout set to 600, and we are talking MS CRM 3.0.

Thanks.