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