This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
admin:indexing:powersearch:optimization [2011/01/24 15:29] 127.0.0.1 external edit |
admin:indexing:powersearch:optimization [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ~~NOTOC~~ | ~~NOTOC~~ | ||
| + | |||
| {{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
| Line 10: | Line 11: | ||
| [[admin:indexing:powersearch:sql|SQL]] | | [[admin:indexing:powersearch:sql|SQL]] | | ||
| **[[admin:indexing:powersearch:optimization|Optimization]]** | | **[[admin:indexing:powersearch:optimization|Optimization]]** | | ||
| + | [[admin:indexing:powersearch:custom|Customization]] | | ||
| [[admin:indexing:powersearch:tips|Tips]] | [[admin:indexing:powersearch:tips|Tips]] | ||
| ---- | ---- | ||
| + | ==== The Optimization Behind PowerSearch ==== | ||
| + | Generally there is no additional optimization needed for PowerSearch. PowerSearch generally consists of increasing the number of search terms used in a query. For example, a query that would search for a given name of 'William' can be expanded to include "William, Bill, Billy, Will, Williams, Willie, Willis, Wilson". Presuming that Omnidex indexing has already been established to optimize the original search, it will also optimize the expanded search. | ||
| - | ==== The Optimization Behind PowerSearch ==== | + | === Enabling MISSPELLINGS === |
| + | |||
| + | Applications that wish to use the MISSPELLINGS feature (which also encompasses transposition and typographical errors) will need to perform an [[dev:sql:statements:update_text:home|UPDATE TEXT]] statement on their database after indexing. This command will evaluate the data in the database and create custom dictionaries used to identify the misspelled entries in the database. | ||
| + | |||
| + | === Enabling PHONETIC === | ||
| + | |||
| + | Applications that wish to use the PHONETIC feature must create an Omnidex index that uses the PHONETIC option. This option indexes the phonetic equivalent of a word as well as the word itself. Consult the [[admin:indexing:indexes:options#phonetic|documentation]] on this option for more details. | ||
| + | |||
| + | === Enabling Geographic Radius Searches === | ||
| + | Applications that wish to use Geographic Radius Searches, such as those shown with the zip code in the previous page, will need to have a table of zip codes that includes the latitude and longitude for each zip code. These are available from a number of sources, including inexpensive downloads on the Internet. Remember that zip codes change on a regular basis, so accuracy depends on keeping this table updated on a regular database. | ||
| + | Once the table is established, it must be indexed for geographic radius searches. Consult the [[admin:features:geo:home|documentation]] about these searches for more details. | ||
| ===== ===== | ===== ===== | ||
| **[[admin:indexing:powersearch:sql|Prev]]** | | **[[admin:indexing:powersearch:sql|Prev]]** | | ||
| - | **[[admin:indexing:powersearch:tips|Next]]** | + | **[[admin:indexing:powersearch:custom|Next]]** |
| ====== Additional Resources ====== | ====== Additional Resources ====== | ||