- see footer for list info -<
The company likes the idea of the dropdown of users though, and would
like to keep it.
Tell them no.
It's ridiculous to have a drop-down with 100k items - with that many entries
it has to be an textbox.
If usernames are long, you could consider doing a dynamic lookup after
typing the first three/four characters, and offering the most likely
candidates.
If you can't wait for CF8 (which I believe has a control that will do this),
you'll probably be able to find plenty of examples if you google for
something like "text autocomplete javascript widget" or similar, otherwise I
can write a quick example of it.
On 6/29/07, Andrew Davidson <[EMAIL PROTECTED]> wrote:
>- see footer for list info -<
hi,
i ma trying to improve performance and useability on a page I have
inherited. Currenbtly, there is a dropdown at the top of the page that loads
all th users in the system. This is just a simple dropwn, so you pick a
user, the whole page reloads (with that userid sent as a URL parameter) and
displays all the graphs and info for that user. This works perfectly fine
with a small amount of users. The company has now had massive growth, and
the number of users in the system is now something like 100,000+, and now
the page is taking way too long to load (over 10secs sometimes). There are 2
thiings slowing it down, the stored proc to get the list of users is taking
a few secs, but the main problem is that the size of the html page returned
to the browser to load (with 100,00+ options in the user select dropdown) is
about 4MB. Combined, this makes the page sooo slow. The company likes the
idea of the dropdown of users though, and would like to keep it. Is this a
case for AJAX ? I
am familiar with AJAX, and have used it in a small scale before, but not
for anything this big. If i were to use it, I would need to start populating
the dropdown when the page loaded (so would not be waiting for an onClick or
an onChange event), would the page still be useable (ie, could a user still
click on all the other stuff on the page, would it still scroll, etc) ?
Also, would it still have the same problems with about 4MB of data being
sent to it to display ? Also, the user would still have to wait quite a
while with the drop down saying just "loading" or something while the data
was being collected and sent back to the page, so woudl still not be ideal.
Would anyone have any suggestions about how you could display a very large
dropdown (large amount of otpions), without have to use an actual select
list dropdown (if that makes sense) ? How have other people presented an
extremely large option slelect list to users ? any ideas appreciated
___________________________________________________________
Yahoo! Answers - Got a question? Someone out there knows the answer. Try
it
now.
http://uk.answers.yahoo.com/
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
>- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -<
>- Lists hosted by www.Gradwell.com -<
>- CFdeveloper is run by Russ Michaels, feel free to volunteer your help
-<
--
\ \
Peter Boughton
blog.bpsite.net
/ /
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
