In simple XML, when I am attempting to load 122K unique records in the dropdown menu, my whole page freezes for a while. I have tried using lookups instead of ad-hoc search, but not able to load the page without freezing.
But one quick question what happens if a user can use wildcard(*) instead of the string. This will load whole the dropdown and then page gets freeze. I don't want to freeze my page. Is it possible if i can give "see more" type in dropdown?
What is the format of the results from the dropdown? Is it a structured? Can the data be grouped? For example, if it was a list of 122k Surnames, perhaps you could first create a dropdown to select the first letter(Using static values - the alphabet)? Passing that as a token to your main drop down would roughly divide the results by 26?