This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
admin:indexing:autocomplete:optimization [2011/01/24 22:03] els |
admin:indexing:autocomplete:optimization [2016/06/28 22:38] (current) |
||
---|---|---|---|
Line 17: | Line 17: | ||
==== The Optimization Behind AutoComplete ==== | ==== The Optimization Behind AutoComplete ==== | ||
- | There is no special optimization that is required to use AutoComplete. AutoComplete can be performed against column that is indexed with an Omnidex or QuickText index. Note that QuickText indexes require the use of the 'optimization=distinct_key' option as shown on the previous page. | + | There is no special optimization that is required to use AutoComplete, other than insuring that these queries are performed against columns indexed with an Omnidex or QuickText index. Note that QuickText indexes require the use of the 'optimization=distinct_key' option as shown on the previous page. |
+ | The performance of AutoComplete stems from Omnidex's ability to quickly aggregate data. In AutoComplete queries, Omnidex scans its own indexes to determine the values that match the criteria and return their counts. | ||