Quick Find is a basic navigation tool to help you find specific records in CRM 2011. Quick Find optimizations have been included in Dynamics CRM 2011 Update Rollup 10 (UR10). By default, these are enabled after applying UR10; however, you can disable them using the option in System Settings:
(Settings | Administration | System Settings | General Tab)
The setting is at the bottom of the “General” tab called “Enable Quick Find Record Limits,” which is set to “Yes” by default.
When the optimizations are enabled, if more than 10,000 records are returned by a Quick Find query, the following error will occur: “Quick find limit exceeded. Please use a more selective search value, or use Advanced Find for your search.”
If users need to search using terms that will potentially match over 10,000 records, this setting can be disabled. However, disabling the setting may result in slower overall performance for Quick Find queries. A more appropriate tool for such queries would be to use Advanced Find.
In order to take full advantage of the new Quick Find optimizations, customers will need to implement custom SQL indexes on their Find Columns. As SQL indexes currently cannot be created in CRM Online, this can only be done in On Premise.
If you have a custom field on the Contact entity called po_CustomField, and you have enabled this as a Find Column for Quick Find searches. In order to take full advantage of the new optimizations, create the index:
CREATE NONCLUSTERED INDEX IndexName
ON [dbo].[ContactExtensionBase] ([po_CustomField])
You can optimize the way query performance by modifying the way CRM displays the query results. With the release of Dynamics CRM 2011 UR10, we can now limit the search results returned by quick find and also utilize the new Quick Find query structure by implementing SQL indexes on the column or set of columns used in a Quick Find query.
For more information on performance improvements in Dynamics CRM 2011 UR10 and Quick Find queries please Optimizing and Maintaining a Microsoft Dynamics CRM 2011 Server Infrastructure Performance white paper.
Latest posts by JoeCRM (see all)
- How to Assign a Territory to a Lead in Dynamics CRM - May 17, 2013
- Out of the Box Report: Dynamics CRM User Summary - May 16, 2013
- Dynamics CRM / XRM Integration with GIS and PowerMap - May 15, 2013