Precision Searching
Revision as of 19:15, 13 August 2012 by Philip Lacey (talk | contribs) (Created page with "On large databases like searching induces an unacceptable overhead. Database: 1.2 million customer records Timing (with fuzzy searching): 16.2 seconds average Timing...")
Revision as of 19:15, 13 August 2012 by Philip Lacey (talk | contribs) (Created page with "On large databases like searching induces an unacceptable overhead. Database: 1.2 million customer records Timing (with fuzzy searching): 16.2 seconds average Timing...")
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.