Precision Searching - Revision history

Philip Lacey at 17:46, 18 January 2016

2016-01-18T17:46:58Z

Philip Lacey at 17:35, 18 January 2016

2016-01-18T17:35:04Z

Philip Lacey at 13:49, 16 July 2015

2015-07-16T13:49:11Z

Philip Lacey at 13:44, 16 July 2015

2015-07-16T13:44:15Z

Philip Lacey at 13:35, 16 July 2015

2015-07-16T13:35:37Z

Philip Lacey at 13:34, 16 July 2015

2015-07-16T13:34:51Z

Philip Lacey at 13:34, 16 July 2015

2015-07-16T13:34:33Z

Philip Lacey at 23:22, 9 November 2014

2014-11-09T23:22:44Z

Philip Lacey at 02:06, 22 March 2014

2014-03-22T02:06:24Z

Philip Lacey at 18:18, 13 August 2012

2012-08-13T18:18:47Z

← Older revision		Revision as of 17:46, 18 January 2016
Line 48:		Line 48:


−	N.B. A precision match means that case sensitivity is also adhered to. i.e. "bxp ~~software~~" is not the same as "~~business express~~"	+	N.B. A precision match means that case sensitivity is also adhered to. i.e. "bxp Software" is not the same as "bxp software"

← Older revision		Revision as of 17:35, 18 January 2016
Line 14:		Line 14:
	* Timing (with precision searching): 2 seconds average		* Timing (with precision searching): 2 seconds average
	* Timing (with precision searching and custom index): 0.59 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 =

@@ Line 43: / Line 43: @@
 {| class="wikitable"
 |-
 ! first_name
 ! last_name
@@ Line 50: / Line 51: @@
 ! city
 |-
-| Emma || Lacey || Product 1 || Alan D Rosenburg Cpa Pc || 14 Taylor St || St. Stephens Ward
+| 1 || Emma || Lacey || Product 1 || Alan D Rosenburg Cpa Pc || 14 Taylor St || St. Stephens Ward
 |-
-| Evan || Zigomalas || Product 1 || Cap Gemini America || 5 Binney St || Abbey Ward
+| 2 || Evan || Zigomalas || Product 1 || Cap Gemini America || 5 Binney St || Abbey Ward
 |-
-| France || Andrade || Product 1 || Elliott, John W Esq || 8 Moor Place || East Southbourne and Tuckton W
+| 3 || France || Andrade || Product 1 || Elliott, John W Esq || 8 Moor Place || East Southbourne and Tuckton W
 |-
-| Ulysses || Mcwalters || Product 1 || Mcmahan, Ben L || 505 Exeter Rd || Hawerby cum Beesby
+| 4 || Ulysses || Mcwalters || Product 1 || Mcmahan, Ben L || 505 Exeter Rd || Hawerby cum Beesby
 |-
-| Tyisha || Veness || Product 1 || Champagne Room || 5396 Forth Street || Greets Green and Lyng Ward
+| 5 || Tyisha || Veness || Product 1 || Champagne Room || 5396 Forth Street || Greets Green and Lyng Ward
 |-
-| Eric || Rampy || Product 1 || Thompson, Michael C Esq || 9472 Lind St || Desborough
+| 6 || Eric || Rampy || Product 1 || Thompson, Michael C Esq || 9472 Lind St || Desborough
 |-
-| Marg || Grasmick || Product 1 || Wrangle Hill Auto Auct & Slvg || 7457 Cowl St #70 || Bargate Ward
+| 7 || Marg || Grasmick || Product 1 || Wrangle Hill Auto Auct & Slvg || 7457 Cowl St #70 || Bargate Ward
 |-
-| Laquita || Hisaw || Product 1 || In Communications Inc || 20 Gloucester Pl #96 || Chirton Ward
+| 8 || Laquita || Hisaw || Product 1 || In Communications Inc || 20 Gloucester Pl #96 || Chirton Ward
 |-
-| Lura || Manzella || Product 1 || Bizerba Usa Inc || 929 Augustine St || Staple Hill Ward
+| 9 || Lura || Manzella || Product 1 || Bizerba Usa Inc || 929 Augustine St || Staple Hill Ward
 |}
-To search by the surname is a difficult process of checking each one.  An index would create an ordered list.  Andrade, Grasmick, Hisaw, Lacey, Manzella, Mcwalters, Rampy, Veness, Zigomalas.  This would make searching far easier, but the duplication of data is a significant overhead.
+To search by the surname is a difficult process of checking each one.  An index would create an ordered list.  Andrade, Grasmick, Hisaw, Lacey, Manzella, Mcwalters, Rampy, Veness, Zigomalas.  This would make searching far easier, but the duplication of data is a significant overhead as a mini dataset is created.

← Older revision		Revision as of 13:44, 16 July 2015
Line 70:		Line 70:


		+	To search by the surname is a difficult process of checking each one. An index would create an ordered list. Andrade, Grasmick, Hisaw, Lacey, Manzella, Mcwalters, Rampy, Veness, Zigomalas. This would make searching far easier, but the duplication of data is a significant overhead.
		+
		+
		+	Indexes can also be grouped, e.g. firstname and surname. Indexes for large data sets are limited to the primary searching fields and the most commonly grouped fields.
		+
		+
		+	It is often sensible to create an index on an "Id" field or an identification field that contains values from another system. Indexing these fields is always useful for speed.
		+
		+
		+	bxp has numerous default indexes added but in custom forms, there is no way to know which field to add indexes to.
		+
		+
		+	If you need to enable a custom index, please contact your business development manager to have the field indexed for you. (support@bxpsoftware.com)

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

@@ Line 50: / Line 50: @@
 ! city
 |-
-| Emma | Lacey | Product 1 | Alan D Rosenburg Cpa Pc | 14 Taylor St | St. Stephens Ward
+| Emma || Lacey || Product 1 || Alan D Rosenburg Cpa Pc || 14 Taylor St || St. Stephens Ward
 |-
-| Evan | Zigomalas | Product 1 | Cap Gemini America | 5 Binney St | Abbey Ward
+| Evan || Zigomalas || Product 1 || Cap Gemini America || 5 Binney St || Abbey Ward
 |-
-| France | Andrade | Product 1 | Elliott, John W Esq | 8 Moor Place | East Southbourne and Tuckton W
+| France || Andrade || Product 1 || Elliott, John W Esq || 8 Moor Place || East Southbourne and Tuckton W
 |-
-| Ulysses | Mcwalters | Product 1 | Mcmahan, Ben L | 505 Exeter Rd | Hawerby cum Beesby
+| Ulysses || Mcwalters || Product 1 || Mcmahan, Ben L || 505 Exeter Rd || Hawerby cum Beesby
 |-
-| Tyisha | Veness | Product 1 | Champagne Room | 5396 Forth Street | Greets Green and Lyng Ward
+| Tyisha || Veness || Product 1 || Champagne Room || 5396 Forth Street || Greets Green and Lyng Ward
 |-
-| Eric | Rampy | Product 1 | Thompson, Michael C Esq | 9472 Lind St | Desborough
+| Eric || Rampy || Product 1 || Thompson, Michael C Esq || 9472 Lind St || Desborough
 |-
-| Marg | Grasmick | Product 1 | Wrangle Hill Auto Auct & Slvg | 7457 Cowl St #70 | Bargate Ward
+| Marg || Grasmick || Product 1 || Wrangle Hill Auto Auct & Slvg || 7457 Cowl St #70 || Bargate Ward
 |-
-| Laquita | Hisaw | Product 1 | In Communications Inc | 20 Gloucester Pl #96 | Chirton Ward
+| Laquita || Hisaw || Product 1 || In Communications Inc || 20 Gloucester Pl #96 || Chirton Ward
 |-
-| Lura | Manzella | Product 1 | Bizerba Usa Inc | 929 Augustine St | Staple Hill Ward
+| Lura || Manzella || Product 1 || Bizerba Usa Inc || 929 Augustine St || Staple Hill Ward
 |}

@@ Line 44: / Line 44: @@
 |-
 ! first_name
-| last_name
+! last_name
-| primary interest
+! primary interest
-| company_name
+! company_name
-| address
+! address
-| city
+! city
 |-
 | Emma | Lacey | Product 1 | Alan D Rosenburg Cpa Pc | 14 Taylor St | St. Stephens Ward

@@ Line 1: / Line 1: @@
-On large databases ''like'' searching induces an unacceptable overhead.
+= Background =
 * Database:						1.2 million customer records
@@ Line 23: / Line 31: @@
-A precision match means that case sensitivity is also adhered to. i.e. "bxp software" is not the same as "business express"
+ N.B. 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.

@@ Line 28: / Line 28: @@
-[[Category:Learning:Contact Centre]]
+[[Category:Topic:Contact Centre]]
-[[Category:Learning:Customer Relationship Management]]
+[[Category:Topic:Customer Relationship Management]]
 [[Category:Module Specific:Form Management]]

← Older revision		Revision as of 02:06, 22 March 2014
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]]

← Older revision		Revision as of 18:18, 13 August 2012
Line 24:		Line 24:

	A precision match means that case sensitivity is also adhered to. i.e. "bxp software" is not the same as "business express"		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.