Re: Handling Large Select Boxes

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thanks for the responses to this...

The AJAX thing would probably not work as this is a critical piece to the UI, so even though the form would load faster, the users would still really need to wait for the select options to come through before they could actually do any *work* on the page.

The problems are horrific data, in that it has not been cleaned and validated, and there are not linkages, or layers to the data either, so there is literally no way to sub-select, which of course is poor planning by people before me. So, before I can fix the real problem, my stop gap solution was to load the list exactly once, as well as loading the contents into JS, therefore the users can search through to narrow down the list, and then using JS they can select an option and place in the the form element they are dealing with. Load time are much better, but still not great. I guess this is what happens when people get a ton of data before they properly planned to get that much data....

-Brad

Brad Ciszewski wrote:

Perhaps try implementing some AJAX on the page. Therefore, once the page has
loaded, the select tag is populated with different options, without actually
lagging the page.


""Jay Blanchard"" <jblanchard@xxxxxxxxxx> wrote in message
news:56608562F6D5D948B22F5615E3F57E6921BFFC@xxxxxxxxxxxxxxxxxxxxxxxxxx
[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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux