https://www.omnidex.com/docs/v54/ 2026-04-29T20:43:59+0000 https://www.omnidex.com/docs/v54/ https://www.omnidex.com/docs/v54/lib/tpl/simple/images/favicon.ico text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:autocomplete:example&rev=1467153531&do=diff Administration: Omnidex Indexing AutoComplete Overview | Example | SQL | Optimization | Tips ---------- Example In this example of AutoComplete, a user is entering criteria for the First Name column. As they type letters, a pull-down box displays choices that match the letters entered so far. The count for each value is shown, and the list is ordered so that the most common choices appear first. text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:autocomplete:home&rev=1467153531&do=diff Administration: Omnidex Indexing AutoComplete Overview | Example | SQL | Optimization | Tips ---------- Overview Most of us have grown accustomed to AutoComplete in web applications. In many websites, when you start to type something, the web page will automatically present a drop-down box with choices matching the characters you've entered so far. Some sites even present you with the most likely choice first. Internet search engines, like Google and Bing, are examples of sites that do t… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:autocomplete:optimization&rev=1467153531&do=diff Administration: Omnidex Indexing AutoComplete Overview | Example | SQL | Optimization | Tips ---------- The Optimization Behind AutoComplete 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. text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:autocomplete:sql&rev=1467153531&do=diff Administration: Omnidex Indexing AutoComplete Overview | Example | SQL | Optimization | Tips ---------- The SQL Behind AutoComplete The SQL behind AutoComplete is a simple query requesting grouped counts. For QuickText indexes, it is necessary to use an optimization setting so that one value is returned for each parsed word, rather than one value for each row. text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:autocomplete:tips&rev=1467153531&do=diff Administration: Omnidex Indexing AutoComplete Overview | Example | SQL | Optimization | Tips ---------- Implementation Tips The following tips are helpful when implementing AutoComplete in applications: * It is beneficial to wait until the user has typed two or three letters before triggering an AutoComplete query. This will improve the performance of the query and reduce the number of values to be displayed.