Overview | Example | SQL | Optimization | 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.

• It is beneficial to transfer the initial AutoComplete results to local memory and then use the local programming language to continue filtering them as more letters are typed. This reduces the number of queries issued to the database and reduces the impact to system resources.

• It can be beneficial to trigger AutoComplete queries on a timer, rather on a letter count. For instance, the first query might be triggered after one second, with refinements to the pull-down box being triggered in subsequent one-second intervals. This allows fast types to not be slowed down by the work of populating the pull-down.

Prev

See also: