I have a requirement to create a form with Auto-suggest/Auto-complete fields. I want to know what affect such fields have on data retrieval and when exactly is data retreived in such cases. Is the data cached once the form is accessed and used for the Auto-suggest/Auto-complete fields?
There's no set answer for this, simply it depends on how you are doing it. :-D
Probably the route you'll take is AJAX and using the onKeyup method. with each onKeyup you either run a database query searching for [WHERE X LIKE value+'%'] or search through an external text file or something.