RE: [PHP] Handling Large Select Boxes
| From: | Jay Blanchard | Date: | Fri, 07 Apr 2006 15:57:11 +0000 |
| Subject: | RE: [PHP] Handling Large Select Boxes | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-233436@lists.php.net to get a copy of this message | ||
[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?