The following is a multi-part blog series discussing RetrieveMultiple query performance. RetrieveMultiple is the retrieval of one or more entity instances based on specified criteria. This type of query will be executed by all users when retrieving CRM data. When this executes, security needs to be taken into consideration if the query is executed by someone that does not have administrative access, or full read rights to the entity being retrieved. The additional security checks often will lead to performance issues for the end user trying to retrieve data.
1. RetrieveMultiple Intro.
2. RetrieveMultiple Administrator Query.
5. Sharing Considerations.
6. IdsCount* Settings.
7. Other Considerations.
· Utilize the OrgDbOrgSettings Tool to retrieve or modify the information via Command Prompt.
· Install the OrgDbOrgSettings Solution to retrieve or modify the information via the UI.
· Execute the following query to retrieve the data directly from the database if necessary:
select OrgDbOrgSettings from OrganizationBase