Precision Searching
On large databases like searching induces an unacceptable overhead.
Database: 1.2 million customer records
Timing (with fuzzy searching): 16.2 seconds average
Timing (with precision searching): 2 seconds average
Timing (with precision searching and custom index): 0.59 seconds average
To enable precision searching for any client:
1. Main Menu > Database Management > Field Mapping > Select the campaign > identify the full field name of the column e.g strCDA_X_field_0_0
2. Main Menu > Database Management > Database – Primary Management > Campaign – Edit > Select the campaign > Advanced Options > Precision Search Fields
3. In this box put the field identified in item 1.
Multiple fields may be made precise using this method, simply add multiple fields separated by commas to this same box.
A precision match means that case sensitivity is also adhered to. i.e. "bxp software" is not the same as "business express"