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?


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to