Increasing the GridViewRecordCap to more than 500
Working with a customer who has a request offering that prompts the user to select users from an AD query to add to an email distribution list. There are approx. 7000 users in AD. The GridViewRecordCap is limited to 500 which makes it difficult to select a user outside of the initial 500 users returned. If you type in the username, it auto-populates but only if the user is within the initial 500 users. Anyone outside of that limit is not returned. Increasing the limit to 7000 creates a delay of approx. 15 seconds for the list to display as the load on the database increases.
What is the best method of achieving this? I think it may be a case of trying to identify common attributes of the users that would be select such as same dept or team so that we can try to restrict the output list based on a previous prompt.