Anonymous, bureaucrat, administrator
7,528
edits
Changes
no edit summary
* Timing (with precision searching): 2 seconds average
* Timing (with precision searching and custom index): 0.59 seconds average
= Database query =
In the background the system creates a database query to do the lookup. In a normal fuzzy search the query will have in the where clause "Where strCDA_X_field_0_0 like '%yourValue%'"
After turning on precision searching the query will now read as "Where strCDA_X_field_0_0 = 'yourValue'"
The % wildcard charcters are removed and the like statement is changed to a precision match.
= Enabling Precision Searching =