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. "Business Express" is not the same as "business express"

If you need to enable a custom index, please contact your account manager to have the field indexed for you.