Re: Handling Large Select Boxes

Good point... Maybe the gods of usability can kick the user's in the butt to get them to clean up the data! Previously they used a free text field, which is why the problem is as bad as it is currently.... All the data has to be available, so the only other option I can think of is to select 1 letter and then have Javascript populate the sub-select box... unless someone has any other ideas? -B Jay Blanchard wrote:

[snip] I have a form for user interaction and part of it is a select box with a large number of options from a database ~12K options. Currently I have a function which queries the DB to get fresh data and loads the HTML (<option value=X>Y</option>) into a string, so the DB is only hit once, but the page still takes a while to load. Anyone else have any experience with something like this, or any other helpful suggestions for making the page load time a little less cumbersome? [/snip] If you are loading 12000 entries into a select box then that is way too much. The gods of usability frown on you. Is there no way to make the data selection slimmer?