Difference between revisions of "Precision Searching"
From All n One's bxp software Wixi
Philip Lacey (talk | contribs) |
Philip Lacey (talk | contribs) |
||
| Line 26: | Line 26: | ||
If you need to enable a custom index, please contact your account manager to have the field indexed for you. | If you need to enable a custom index, please contact your account manager to have the field indexed for you. | ||
| + | |||
| + | |||
| + | [[Category:Learning:Contact Centre]] | ||
| + | [[Category:Learning:Customer Relationship Management]] | ||
| + | |||
| + | [[Category:Module Specific:Form Management]] | ||
Revision as of 03:06, 22 March 2014
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"
If you need to enable a custom index, please contact your account manager to have the field indexed for you.